topic Re: Expression... in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/664245#M241898 <HTML><HEAD></HEAD><BODY><P>in script itself</P><P></P><P>you could use if(len(Material)&gt;0,Material,'Blank')</P><P></P><P>and in formula </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count(Distinct If(Material&lt;&gt;'Blank',Material))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">and dimesion you could take status and <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">executiondate</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">hope this helps<BR /></SPAN></P></BODY></HTML> Sat, 12 Jul 2014 09:10:46 GMT SunilChauhan 2014-07-12T09:10:46Z Expression... https://community.qlik.com/t5/QlikView/Expression/m-p/664240#M241893 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am having a table with 2 dimensions execution date and status and I wan count of only those materials which are present in all these execution dates.</P></BODY></HTML> Sat, 12 Jul 2014 05:36:16 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/664240#M241893 2014-07-12T05:36:16Z Re: Expression... https://community.qlik.com/t5/QlikView/Expression/m-p/664241#M241894 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>Can you explain little bit more.</P><P>Like Status is always present even if your execution date is not present?</P><P>If yes,</P><P></P><P>Then try like this,</P><P>count(status={"=not isnull(execution_Date)"}materials)</P><P></P><P>It is better if you share sample data.</P><P></P><P>Regards</P></BODY></HTML> Sat, 12 Jul 2014 05:46:28 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/664241#M241894 PrashantSangle 2014-07-12T05:46:28Z Re: Re: Expression... https://community.qlik.com/t5/QlikView/Expression/m-p/664242#M241895 <HTML><HEAD></HEAD><BODY><P>please find attached sample data.</P></BODY></HTML> Sat, 12 Jul 2014 05:56:51 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/664242#M241895 2014-07-12T05:56:51Z Re: Expression... https://community.qlik.com/t5/QlikView/Expression/m-p/664243#M241896 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have checked your sample data.</P><P></P><P>How you calculating status as you mention in your question?</P><P>I did not find any materials with our execution date?</P><P></P><P>Regards,</P></BODY></HTML> Sat, 12 Jul 2014 06:17:22 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/664243#M241896 PrashantSangle 2014-07-12T06:17:22Z Re: Expression... https://community.qlik.com/t5/QlikView/Expression/m-p/664244#M241897 <HTML><HEAD></HEAD><BODY><P>Count(Distinct Material)</P></BODY></HTML> Sat, 12 Jul 2014 07:20:29 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/664244#M241897 MK_QSL 2014-07-12T07:20:29Z Re: Expression... https://community.qlik.com/t5/QlikView/Expression/m-p/664245#M241898 <HTML><HEAD></HEAD><BODY><P>in script itself</P><P></P><P>you could use if(len(Material)&gt;0,Material,'Blank')</P><P></P><P>and in formula </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count(Distinct If(Material&lt;&gt;'Blank',Material))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">and dimesion you could take status and <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">executiondate</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">hope this helps<BR /></SPAN></P></BODY></HTML> Sat, 12 Jul 2014 09:10:46 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/664245#M241898 SunilChauhan 2014-07-12T09:10:46Z