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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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