Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator
Creator

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
Creator
Author

2 Replies
Quy_Nguyen
Specialist
Specialist

Hi,

Try this expression for Dimension Region:

Dual(Region, SalesID)

jjustingkm
Creator
Creator
Author

thank you Nguyen