Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
saminouari
Contributor III
Contributor III

Count If Dimension equal to

Hi,

I want to count values >=1 of column "C" excluding zero values. For example : The total values of column "C" is 9, but what I want to do is to count values>=1 which give me a result of 6.

I tried different scripts such as : Count(If({'TV OLED'} Display>=1,1,null()))

ggg.PNG

Labels (1)
1 Solution

Accepted Solutions
saminouari
Contributor III
Contributor III
Author

@bharathadde I find a solution Count(DISTINCT(if(Display> 0,Store)))

View solution in original post

2 Replies
bharathadde
Creator II
Creator II

Try this 

=Count({<Display={">0"}>}Display)

saminouari
Contributor III
Contributor III
Author

@bharathadde I find a solution Count(DISTINCT(if(Display> 0,Store)))