Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
dnowebdn
Contributor
Contributor

expression

Hi,

I need your suggestions on the field.

2 Replies
OmarBenSalem

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

Anil_Babu_Samineni

What suggestion you want? Question itself not filled?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful