Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Logic issue

Hi all ,

In the below customized report my expression showing wrong results.can any one help me on this

my exp: if(ELECTRICITY_DUTY=0,Count(distinct CONNECTION_NO))

what to do if I want to get only Electricity duty Not counted accounts with 0 symbol, Expression showing all accounts.

Screenshot (11).png

Labels (1)
10 Replies
Anonymous
Not applicable
Author

Try:

Count( {<ELECTRICITY_DUTY-= {0}>} distinct CONNECTION_NO)