topic Re: Can Anyone write this better (Set Analysis) in QlikView https://community.qlik.com/t5/QlikView/Can-Anyone-write-this-better-Set-Analysis/m-p/1359978#M839427 <HTML><HEAD></HEAD><BODY><P>Why you want to open another thread for this?</P><P><A href="https://community.qlik.com/message/1261134">Re: set analysis help</A></P></BODY></HTML> Wed, 03 May 2017 16:15:40 GMT Anil_Babu_Samineni 2017-05-03T16:15:40Z Can Anyone write this better (Set Analysis) https://community.qlik.com/t5/QlikView/Can-Anyone-write-this-better-Set-Analysis/m-p/1359977#M839426 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">sum</STRONG></SPAN><STRONG style="font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">({$&lt;</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">ProductCode</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">={</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">"???"</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">}, PNO = {'$(=Len(PNO)&lt;9)'}&gt;}</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">SPAMT</SPAN></STRONG><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">)</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG style="font-style: inherit; font-size: 13.3333px; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt;"><STRONG style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">sum</STRONG></SPAN><STRONG style="font-style: inherit; font-size: 10pt;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">({$&lt;</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">ProductCode</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">={</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">"???"</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">}, PNO = {=Len(PNO)&lt;9}&gt;}</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">SPAMT</SPAN></STRONG><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt;"><STRONG style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">)</STRONG></SPAN></STRONG></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Can-Anyone-write-this-better-Set-Analysis/m-p/1359977#M839426 aaronnayan 2020-11-25T16:16:04Z Re: Can Anyone write this better (Set Analysis) https://community.qlik.com/t5/QlikView/Can-Anyone-write-this-better-Set-Analysis/m-p/1359978#M839427 <HTML><HEAD></HEAD><BODY><P>Why you want to open another thread for this?</P><P><A href="https://community.qlik.com/message/1261134">Re: set analysis help</A></P></BODY></HTML> Wed, 03 May 2017 16:15:40 GMT https://community.qlik.com/t5/QlikView/Can-Anyone-write-this-better-Set-Analysis/m-p/1359978#M839427 Anil_Babu_Samineni 2017-05-03T16:15:40Z Re: Can Anyone write this better (Set Analysis) https://community.qlik.com/t5/QlikView/Can-Anyone-write-this-better-Set-Analysis/m-p/1359979#M839428 <HTML><HEAD></HEAD><BODY><P>May be with double quotes instead of single quotes and no dollar sign expansion</P><P></P><P><STRONG>Sum({$&lt;ProductCode={"???"}, PNO = {"=Len(PNO) &lt; 9"}&gt;}SPAMT)</STRONG></P></BODY></HTML> Wed, 03 May 2017 16:34:04 GMT https://community.qlik.com/t5/QlikView/Can-Anyone-write-this-better-Set-Analysis/m-p/1359979#M839428 sunny_talwar 2017-05-03T16:34:04Z