topic Re: set expression issue in QlikView https://community.qlik.com/t5/QlikView/set-expression-issue/m-p/663896#M241794 <HTML><HEAD></HEAD><BODY><P>Hi Katleen,</P><P></P><P>Try </P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;"> count</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">emptyings_id</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)<BR /> /<BR /> (</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">NullCount</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(<STRONG>TOTAL</STRONG> {&lt;</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">product_status</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'active'}&gt;}</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">inhabitant_until</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)) </SPAN></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Regards.<BR /></SPAN></P></BODY></HTML> Tue, 12 Aug 2014 10:38:25 GMT rubenmarin 2014-08-12T10:38:25Z set expression issue https://community.qlik.com/t5/QlikView/set-expression-issue/m-p/663894#M241792 <HTML><HEAD></HEAD><BODY><P>Can you guys take a look at the attached document?</P><P></P><P>I explained what is going wrong in there.</P><P></P><P>Kind regards,</P><P>Katleen</P></BODY></HTML> Tue, 12 Aug 2014 10:10:22 GMT https://community.qlik.com/t5/QlikView/set-expression-issue/m-p/663894#M241792 2014-08-12T10:10:22Z Re: set expression issue https://community.qlik.com/t5/QlikView/set-expression-issue/m-p/663895#M241793 <HTML><HEAD></HEAD><BODY><P>Put in the same table the expresion separately:</P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">NullCount</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({&lt;</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">product_status</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'active'}&gt;}</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">inhabitant_until</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; line-height: 1.5em;">))</SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; line-height: 1.5em;"><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">NullCount</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({&lt;</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">product_status</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'active'}&gt;}</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">inhabitant_until</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)) </SPAN></SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; line-height: 1.5em;"><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; line-height: 1.5em;"><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">and see their values<BR /></SPAN></SPAN></P></BODY></HTML> Tue, 12 Aug 2014 10:30:11 GMT https://community.qlik.com/t5/QlikView/set-expression-issue/m-p/663895#M241793 ecolomer 2014-08-12T10:30:11Z Re: set expression issue https://community.qlik.com/t5/QlikView/set-expression-issue/m-p/663896#M241794 <HTML><HEAD></HEAD><BODY><P>Hi Katleen,</P><P></P><P>Try </P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;"> count</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">emptyings_id</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)<BR /> /<BR /> (</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">NullCount</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(<STRONG>TOTAL</STRONG> {&lt;</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">product_status</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'active'}&gt;}</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">inhabitant_until</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)) </SPAN></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Regards.<BR /></SPAN></P></BODY></HTML> Tue, 12 Aug 2014 10:38:25 GMT https://community.qlik.com/t5/QlikView/set-expression-issue/m-p/663896#M241794 rubenmarin 2014-08-12T10:38:25Z