Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
pala_jagadeesh
Contributor III
Contributor III

Display unique record

Hi, I have a table in datamodel like below

Rec No product Flag
1 AB 0
1 AA 0
2 BB 0
2 BC 0
3 CV 0
3 CD 0
3 CF 0
4 GH 0
4 GT 0
4 GY 0
1 AC 1
2 BD 1
3 CN 1

 

i want output like below , because rec_no 4 should not share with both flag values , it has value 0 only

Remaining all records share flag values 1 and 0 both

Rec_ No Product
4 GH;GT;GY

 

How to write chart expession in front end to get above output

Labels (2)
11 Replies
pala_jagadeesh
Contributor III
Contributor III
Author

is there any possible to find count in KPI measure,

here count is  3

pala_jagadeesh
Contributor III
Contributor III
Author

@MarcoWedel 

is there possibility to find the count of product in KPI as 3