Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
saminouari
New Contributor II

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
New Contributor II

Re: Count If Dimension equal to

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

View solution in original post

2 Replies
Highlighted
bharathadde
Contributor II

Re: Count If Dimension equal to

Try this 

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

saminouari
New Contributor II

Re: Count If Dimension equal to

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

View solution in original post