Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Using tables to multiply values like indexing or vlookup

Hi There

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).

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.

Is there a way of getting Qlik to make all of these calculations for around 5000 plots of land that are separated out by?

Have attached the two formats i've put it in so far

Thanks!

Sam

Labels (5)
0 Replies