Help with writing an expression to produce value for location Id to correspond with its location
I am very new to qlik sense.
I am trying to build a pivot table for location and location ID. I chose location as dimension, and locationID as measure. I need help writing an expression or syntax that will show each location with its location ID.
It sort of depends on your data model. And its not very clear what you are trying to do.
A measure is an aggregation. concat, max, min, only, count, sum. You can add conditions using set analysis in your measure if say you want where Year = max(Year).
But if you just want to see what location ID are with what location, i would just have a (straight) table and have both as dimensions. Otherwise you have to explain what kind of aggregation you want.
It sort of depends on your data model. And its not very clear what you are trying to do.
A measure is an aggregation. concat, max, min, only, count, sum. You can add conditions using set analysis in your measure if say you want where Year = max(Year).
But if you just want to see what location ID are with what location, i would just have a (straight) table and have both as dimensions. Otherwise you have to explain what kind of aggregation you want.
