Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mashikoo
Contributor
Contributor

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.

Please help!

Labels (5)
1 Solution

Accepted Solutions
stevejoyce
Specialist II
Specialist II

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.  

View solution in original post

2 Replies
stevejoyce
Specialist II
Specialist II

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
Contributor
Contributor
Author

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