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

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
WEBINAR June 25, 2025: Build on Apache Iceberg with Qlik Open Lakehouse - REGISTER TODAY
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Correct_Answer
Contributor III
Contributor III
‎2023-09-12 01:36 PM

How to get unique records from a table, If it is having multiple entries.

Hi Team,

I have one requirement in Qlik, I have one table with few associated records for every product id.

I needs to fetch one record/Sales person to contact for one group based on product id and below logic.

Correct_Answer_2-1694540120689.png

 

 

I needs to find out only one record top hierarchy if manager available in Role I needs to fetch manager record if manager is not available for that product id i need to fetch next hierarchy Sales lead if there any duplicate role we needs to fetch any one of them.

 

Expected Output:

Correct_Answer_1-1694540095065.png

 

Can anyone help in this scenario.

 

Data to copy:

 

Product ID Product Status Sales Person Role
XAM85201 Food Warehouse1 John Sales Person
XAM85201 Baverages Warehouse2 Mark Sales Lead
XAM85201 Cookies Warehouse3 David Sales manager
TDOX5684 Food Warehouse2 Josep Sales Lead
TDOX5684 Food Warehouse3 Victor Sales Lead

 

 

Best Regards,

Labels (1)
Labels
352 Views
0 Likes
0 Replies