topic Re: How to get values based on expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-values-based-on-expression/m-p/663580#M1071507 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you share sample data with expected output.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 12 Aug 2014 11:54:59 GMT ashfaq_haseeb 2014-08-12T11:54:59Z How to get values based on expression? https://community.qlik.com/t5/QlikView/How-to-get-values-based-on-expression/m-p/663579#M1071500 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P></P><P>I have straight table with columns</P><P></P><P>Id, name as dimension</P><P>expression as Category where =If(Category&lt;&gt;'Closed' and Status&lt;&gt;'closed', Category)</P><P>another expression as =Count(distinct(If(IsNull(Dateclosed),ID)))</P><P></P><P>when I am selecting 'Closed', 'closed' in Category list box the table is showing values where it should not show values based on above condition.. Is there any wrong in expression. Please can anyone suggest me.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 12 Aug 2014 11:45:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-based-on-expression/m-p/663579#M1071500 2014-08-12T11:45:39Z Re: How to get values based on expression? https://community.qlik.com/t5/QlikView/How-to-get-values-based-on-expression/m-p/663580#M1071507 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you share sample data with expected output.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 12 Aug 2014 11:54:59 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-based-on-expression/m-p/663580#M1071507 ashfaq_haseeb 2014-08-12T11:54:59Z