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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator II
Creator II

Display duplicates ( hide column)

I have a table with data like below.

 

sales I’d Region Supplier

100.          ABC        DD

101.           ABC         DD

I need to hide sales I’d here, without sales I’d , it ends up with only one record since two are duplicates values. Please help

 

1 Solution

Accepted Solutions
jjustingkm
Creator II
Creator II
Author

2 Replies
Quy_Nguyen
Specialist
Specialist

Hi,

Try this expression for Dimension Region:

Dual(Region, SalesID)

jjustingkm
Creator II
Creator II
Author

thank you Nguyen