Help with writing an expression to produce value for location Id to correspond with its location

[mashikoo]

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.

Please help!

[stevejoyce · Accepted solution]

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.  

[mashikoo]

I appreciate your response Steve. having a straight table with both as dimensions gave me my results. Thanks again!