Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
dreweezy
Creator II
Creator II

count if on a column based on their value

Hi all - very new to qlik and still wrapping head around syntax. I am trying to incorporate a count if function to give me the count of values that are <0 and >0. Right now I have as follow:

Count({<ValueColumn >0 >} ValueColumn )

Count({<ValueColumn <0 >} ValueColumn )

I am running into some issues. I followed a different forums syntax but this doesn't seem to hold through. 

Labels (1)
1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

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

Count({<ValueColumn={"<0"}>} ValueColumn )
Learning never stops.

View solution in original post

3 Replies
pradosh_thakur
Master II
Master II

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

Count({<ValueColumn={"<0"}>} ValueColumn )
Learning never stops.
Channa
Specialist III
Specialist III

if(count(ValueColumn )>0,val,val2)

 

just sample

Channa
Channa
Specialist III
Specialist III

if you trying with set analysis

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

Channa