https://community.qlik.com/t5/QlikView/Using-tables-to-multiply-values-like-indexing-or-vlookup/m-p/1547028#M598650 <P>Hi There</P><P><BR />My problem looks at different plots of land and the amount of hectares that they have. For each plot of land there is a ha value and a land type (Coastal, Farmland, Grassland, Freshwater, Mountain, Woodland, Marine and Urban).</P><P><BR />For each of these 8 values there are another 8 different 'value' areas (i.e value from Absorbing particulates for air quality). The plot of land figure is split out by habitat type and then multiplied by the resulting value area.</P><P><BR />Is there a way of getting Qlik to make all of these calculations for around 5000 plots of land that are separated out by?<BR />Have attached the two formats I've put it in so far</P><P>Thanks!</P><P>Sam</P> Sat, 16 Nov 2024 04:23:11 GMT samfrankland 2024-11-16T04:23:11Z https://community.qlik.com/t5/QlikView/Using-tables-to-multiply-values-like-indexing-or-vlookup/m-p/1547028#M598650 <P>Hi There</P><P><BR />My problem looks at different plots of land and the amount of hectares that they have. For each plot of land there is a ha value and a land type (Coastal, Farmland, Grassland, Freshwater, Mountain, Woodland, Marine and Urban).</P><P><BR />For each of these 8 values there are another 8 different 'value' areas (i.e value from Absorbing particulates for air quality). The plot of land figure is split out by habitat type and then multiplied by the resulting value area.</P><P><BR />Is there a way of getting Qlik to make all of these calculations for around 5000 plots of land that are separated out by?<BR />Have attached the two formats I've put it in so far</P><P>Thanks!</P><P>Sam</P> Sat, 16 Nov 2024 04:23:11 GMT https://community.qlik.com/t5/QlikView/Using-tables-to-multiply-values-like-indexing-or-vlookup/m-p/1547028#M598650 samfrankland 2024-11-16T04:23:11Z