Showing right values according to set analysis

linoyel — Mon, 04 Aug 2014 07:19:18 GMT

Hey all, I really need your help

I have to show sum of sales for agents who sold less then 10000 (and a few more conditions in set analysis).

It lookls like this:

=If ($(NetSum_upgrade_current)<=10000, Sum({$<$(s.Month.Current), SaleType_id = {0}, user_group_ID = {1}>} income), 0)

As you can see, if the condition is false (for example, agent who sold > 10000), I put value = 0 and then I check "suppress zero values" so it won't be shown in a table.

The problem is agents that sold 0! When it's a real 0 and not 0 because of the false condition - I need them to be in the table as well!

Is there any option to change 0 by smth else in the condition, lets say by -11111 and then suppress this value?

Any help would be appreciated

Re: Showing right values according to set analysis

avinashelite — Mon, 04 Aug 2014 07:34:42 GMT

Hi Linoy,

Replace 0 by some thing like '' and try with suppress missing.

Re: Showing right values according to set analysis

linoyel — Mon, 04 Aug 2014 09:10:01 GMT

Thank you very much, Avinash!

That worked

topic Re: Showing right values according to set analysis in QlikView

Showing right values according to set analysis

Re: Showing right values according to set analysis

Re: Showing right values according to set analysis