topic Problem in count and normal expression in QlikView https://community.qlik.com/t5/QlikView/Problem-in-count-and-normal-expression/m-p/345557#M127789 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I have a expression that is being used in bar chart and it is giving some value for count of Ids. When I am using the same expression in straight table to see those Ids then it is giving nothing. I am unable to get it. As this is confidential data so could not share it.</P><P></P><P>Count(Distinct If(condtn A AND condtn B,ReportId,Null()))&nbsp; it is giving some value</P><P>and when i am using If(condtn A AND condtn B,ReportId,Null()) in a straight table to see those ReportIds it is giving - for all.</P><P>Kindly suggest some debugging methods to solve it</P></BODY></HTML> Thu, 10 May 2012 05:45:19 GMT 2012-05-10T05:45:19Z Problem in count and normal expression https://community.qlik.com/t5/QlikView/Problem-in-count-and-normal-expression/m-p/345557#M127789 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I have a expression that is being used in bar chart and it is giving some value for count of Ids. When I am using the same expression in straight table to see those Ids then it is giving nothing. I am unable to get it. As this is confidential data so could not share it.</P><P></P><P>Count(Distinct If(condtn A AND condtn B,ReportId,Null()))&nbsp; it is giving some value</P><P>and when i am using If(condtn A AND condtn B,ReportId,Null()) in a straight table to see those ReportIds it is giving - for all.</P><P>Kindly suggest some debugging methods to solve it</P></BODY></HTML> Thu, 10 May 2012 05:45:19 GMT https://community.qlik.com/t5/QlikView/Problem-in-count-and-normal-expression/m-p/345557#M127789 2012-05-10T05:45:19Z