topic Re: Not equal symbol in set analysis in QlikView

Not equal symbol in set analysis

raju_salmon — Fri, 25 Dec 2015 06:10:38 GMT

Hi,

Not equal symbol work in SET ANALYSIS?

Expression error is showing for me.

Count({$<Sales<>{0}>}Sales) - Not working

Count({$<Sales={0}>}Sales) - working

I want to exclude 0 sales. How can we use not equal in set analysis?

Thanks.

Raju.

Gysbert_Wassenaar — Fri, 25 Dec 2015 06:17:40 GMT

Try: Count({$<Sales<>{'>0<0'}>}Sales)

But since negative Sales are not possible (afaik) this can be used: Count({$<Sales={'>0'}>}Sales)

This often works too: Count({$<Sales-={0}>}Sales)