Set analysis in pivot chart does not work properly with dimension

[#1]

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 !

[jagan · Accepted solution]

Hi,

Try this expression

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

Regards,

Jagan.

[#3]

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