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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

10 Replies
Anonymous
Not applicable
Author

Try:

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