topic How To Avoid Synthetic Key in QlikView https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364138#M821266 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i have source table as shown below </P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172684_1.png" style="height: auto;" /></P><P>My expected Result should be </P><P><IMG alt="2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/172691_2.png" style="height: auto;" /></P><P>I have achieved this but I've got some synthetic keys in it. <STRONG>Could anyone say</STRONG> <STRONG>how to avoid these synthetic keys and improve the script?</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vengadeshpalani 2020-11-25T16:16:04Z How To Avoid Synthetic Key https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364138#M821266 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i have source table as shown below </P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172684_1.png" style="height: auto;" /></P><P>My expected Result should be </P><P><IMG alt="2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/172691_2.png" style="height: auto;" /></P><P>I have achieved this but I've got some synthetic keys in it. <STRONG>Could anyone say</STRONG> <STRONG>how to avoid these synthetic keys and improve the script?</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364138#M821266 vengadeshpalani 2020-11-25T16:16:04Z Re: How To Avoid Synthetic Key https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364139#M821267 <HTML><HEAD></HEAD><BODY><P>Check attached</P></BODY></HTML> Mon, 07 Aug 2017 17:58:35 GMT https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364139#M821267 sunny_talwar 2017-08-07T17:58:35Z Re: How To Avoid Synthetic Key https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364140#M821268 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny. But my actual requirement is when I select C1 from "selectcustomer",&nbsp; C1 should not appear in bar chart. But I need to achieve it only by script.</P><P><IMG alt="3.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172692_3.png" style="height: auto;" /></P><P>If we exclude the selecting customer, we can reduce number of rows in data model.</P><P><IMG alt="4.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/172697_4.png" style="height: auto;" /></P></BODY></HTML> Mon, 07 Aug 2017 18:19:54 GMT https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364140#M821268 vengadeshpalani 2017-08-07T18:19:54Z Re: How To Avoid Synthetic Key https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364141#M821269 <HTML><HEAD></HEAD><BODY><P>Check now</P></BODY></HTML> Mon, 07 Aug 2017 18:33:30 GMT https://community.qlik.com/t5/QlikView/How-To-Avoid-Synthetic-Key/m-p/1364141#M821269 sunny_talwar 2017-08-07T18:33:30Z