Discussion board where members can get started with Qlik Sense.
I am looking for a way to display distinct values in a expression for a particular dimension.
Can we do this?
I have records like
Country State City
INDIA AP Hyderabad
INDIA MH Mumbai
USA CA San Fransisco
UK HS London
I want to display this in a table but India should not repeat....it should show blank like a pivot but i want to use table only..
Please help me.
Add a new Measure to the Sense straight table. Use this formula:
The Above() function, with an offset of 1 checks the row above to see if it is identical to the current row.
If you like this, please click 'Correct Answer'.