Discussion board where members can get started with Qlik Sense.
I have loaded data by using SQL and have the table loaded as given below:
1. Let me know how to write the expression to see the duplicate values in a table as seen below
2. Also need another expression to view all the records with a new column added as seen below:
Col1 Col2 Col3
APPLE RED Duplicate
APPLE GREEN Duplicate
ORANGE YELLOW No Duplicate
BANANA BLACK No Duplicate
GRAPES PURPLE Duplicate
GRAPES VIOLET Duplicate
Both have two dimensions Col1 and Col2.
The first table has the expression:
If(Count(TOTAL <Col1> Col1)>1,' ',Null()) or simply If(Count(TOTAL <Col1> Col1)>1,' ')
and the label:
Finally on the Add-Ons remove the checkmark for "Include zero values"
The second table has the expression:
If(Count(TOTAL <Col1> Col1)>1,'Duplicate','No Duplicate')