topic Re. :Show all values with condition in QlikView

Show all values with condition

pljsoftware — Wed, 13 Apr 2011 11:47:00 GMT

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

Re. :Show all values with condition

Wed, 13 Apr 2011 14:30:12 GMT

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

Re: Re. :Show all values with condition

pljsoftware — Wed, 13 Apr 2011 14:45:11 GMT

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