Set analysis in pivot chart does not work properly with dimension

Fri, 15 Aug 2014 10:17:20 GMT

Hi All.

I'm a newby in Qlikview, and I need some assistance with set analysis in pivot chart.

I've attached demo app for my question.

If briefly:

Task - calculate products count for each company, where Sales amount for selected month and Product > 0 and Current Rests > 0
Problem - when pivot table is filtered by Company, everything works fine (Table 1), but if all companies selected (Table 2)- product count total for Company1 (Field Assortment (Set)) calculates incorrectly. It shouldn't include Product3, because it has 0 in both fields (Sales and Rests)
Limitations - everything should be calculated in pivot chart.

So, I think, something wrong with my set expression. Any help will be appreciated. Thanks in advance !

Re: Set analysis in pivot chart does not work properly with dimension

jagan — Fri, 15 Aug 2014 10:26:43 GMT

Hi,

Try this expression

count( {<Amount={'>0'}> + <Rests={'>0'}>} DISTINCT ProductId)

Regards,

Jagan.

Fri, 15 Aug 2014 10:36:09 GMT

Thanks for quick response, Jagan! It works perfectly fine! thanks a lot for your time!