Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

List only the duplicate values in the Pivot

Hi Team,

Need your help in displaying only the duplicate values from the data.

Kindly refer the attachment.S_No is the key.

I would like to list the highlighted(all 3 headers) values(only) in the pivot.

It will be great if this can be done in the set analysis instead of modifying the datamodel script

Thanks & Regards

Jeba

11 Replies
Anonymous
Not applicable
Author

Hi Gysbert,

Thanks a lot,it works perfectly.

Regards

Jeba

santhoo_san
Partner - Creator II
Partner - Creator II

Hi See, whether this help?