Show all values with condition

[pljsoftware]

Hi all!

I have a sales report in which I must show also the articles that aren't been sold (therefore with sales equals to 0). I can't use the options "Show all Values" because, in my situation, not all the real products must be shown: every article has a validity period, so I must show only the products whose validity falls within the selected period, even if they have sells equals to 0.

On this forum I have found a solution (http://community.qlik.com/forums/t/24912.aspx) with a SUM-IF expression, but with large data it takes too much time to be executed, so effectively it can't be used. Does anyone have other idea to solve this problem?

Thanks in advance
Luca

------------------------------------

Luca Jonathan Panetta

PLJ Software

[#2]

I did some tests within your application by linking the I tables with the other ones.

Can you check and tell me if that helps ?

Regards.

Philippe

[pljsoftware]

Hi Philippe,

sorry but this not help me. I want a Pivot Table, you have only create a new table box that contains only my data.

------------------------------------

Luca Jonathan Panetta

PLJ Software