Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dnowebdn
New Contributor

expression

Hi,

I need your suggestions on the field.

2 Replies
omarbensalem
Esteemed Contributor

Re: count

Maybe

count({<Amount={">0"}>}FieldName)

or

count(distinct {<Amount={">0"}>}FieldName)


or

count({<[Field Name]={"=sum({1}AMOUNT)=0"}>} [Field Name])


or


count( distinct {<[Field Name]={"=sum({1}AMOUNT)=0"}>} [Field Name])


depends what u want to achieve

Re: expression

What suggestion you want? Question itself not filled?