Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in count and normal expression

Hi Guys

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.

Count(Distinct If(condtn A AND condtn B,ReportId,Null()))  it is giving some value

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.

Kindly suggest some debugging methods to solve it

0 Replies