<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class=""><span style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);" class="">I don't know about your data or what you call a "function" here, but yes you need to have it loaded in QGis as a layer (with or without geometry). To do so and supposing you have a .xls or .xlsx file you can install the 'Spreadsheet Layers' plugin, which </span><a href="https://github.com/camptocamp/QGIS-SpreadSheetLayers" class="">adds a "Add spreadsheet layer" entry in "Layer" / "Add new Layer" menu and a corresponding button in the "Layers" toolbar. </a><span style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);" class=""> Alternatively you could maybe convert your data into a .csv file and load it as well. Once your file is loaded you should be able to create the relation. </span><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><br class=""></div></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);">Didier</div><div><br class=""><blockquote type="cite" class=""><div class="">Le 21 mars 2020 à 08:49, Boaz Bar Ilan <<a href="mailto:boazprosie@gmail.com" class="">boazprosie@gmail.com</a>> a écrit :</div><br class="Apple-interchange-newline"><div class=""><div dir="rtl" class=""><div dir="ltr" class="">hi </div><div dir="ltr" class="">thanks</div><div dir="ltr" class=""> I need to present all the functions as one layer so how can this help me?</div></div><br class=""><div class="gmail_quote"><div class="gmail_attr" dir="rtl">בתאריך יום ו׳, 20 במרץ 2020 ב-15:39 מאת Didier Peeters <<a href="mailto:dpeeter1@ulb.ac.be" class="">dpeeter1@ulb.ac.be</a>>:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">Hi,<br class="">
<br class="">
You need to use a Relation, in the project properties (Menu: Project > Properties > Relations). <br class="">
<br class="">
See these videos to understand how it works :<br class="">
<br class="">
<a href="https://youtu.be/MeBnasFHGGQ" target="_blank" rel="noreferrer" class="">https://youtu.be/MeBnasFHGGQ</a><br class="">
<a href="https://youtu.be/OowgI1b2ihw" target="_blank" rel="noreferrer" class="">https://youtu.be/OowgI1b2ihw</a><br class="">
<br class="">
Cheers,<br class="">
<br class="">
Didier<br class="">
<br class="">
> Le 20 mars 2020 à 12:33, Boaz Bar Ilan <<a href="mailto:boazprosie@gmail.com" target="_blank" class="">boazprosie@gmail.com</a>> a écrit :<br class="">
> <br class="">
> hi there<br class="">
> I got data xcls which describes functions in relation to parcells<br class="">
> im trying to import this spreadsheet to a map of parcells and what happen of course that if there are 2 functions in the same parcel - it shows only one!<br class="">
> how can I show 2 functions or more related to the same parcel ?<br class="">
> <br class="">
> I can use the add polygon feature but than it should be done manually one by one<br class="">
> is there different way ?<br class="">
> thanks<br class="">
> boaz<br class="">
> <br class="">
> _______________________________________________<br class="">
> Qgis-user mailing list<br class="">
> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" class="">Qgis-user@lists.osgeo.org</a><br class="">
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer" class="">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer" class="">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">
<br class="">
_______________________________________________<br class="">
Qgis-user mailing list<br class="">
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" class="">Qgis-user@lists.osgeo.org</a><br class="">
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer" class="">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer" class="">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote></div>
</div></blockquote></div><br class=""></body></html>