Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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