Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

praveen1108
Contributor

distinct Dimension Value in Expression

Hi,

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.

Regards,

PK

1 Reply
john_mcturnan
New Contributor III

Re: distinct Dimension Value in Expression

Add a new Measure to the Sense straight table.  Use this formula:

=IF(ABOVE(Country,1)=Country,NULL(),Country)

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

Regards,

John

Community Browser