Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Count({<ValueColumn={">0"} >} ValueColumn ) Count({<ValueColumn={"<0"}>} ValueColumn )
Count({<ValueColumn={">0"} >} ValueColumn ) Count({<ValueColumn={"<0"}>} ValueColumn )
if(count(ValueColumn )>0,val,val2)
just sample
if you trying with set analysis
=Count({<value={">=0"}>}value)