Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
vengadeshpalani
Creator
Creator

How To Avoid Synthetic Key

Hi all,

i have source table as shown below

1.png

My expected Result should be

2.png

I have achieved this but I've got some synthetic keys in it. Could anyone say how to avoid these synthetic keys and improve the script?

1 Solution

Accepted Solutions
3 Replies
sunny_talwar

Check attached

vengadeshpalani
Creator
Creator
Author

Thank you Sunny. But my actual requirement is when I select C1 from "selectcustomer",  C1 should not appear in bar chart. But I need to achieve it only by script.

3.png

If we exclude the selecting customer, we can reduce number of rows in data model.

4.png

sunny_talwar

Check now