topic Missing months in a chart in QlikView

Missing months in a chart

fredericvillemi — Thu, 24 May 2012 08:07:31 GMT

Hi,

this is probably one of the silliest question of this forum but i still can't find a good solution :

i have a datasource with projects and products by month

month, project, product, amount

2012/01, P1, Product1, 10

2012/01, P1, Product2, 10

2012/02, P1, Product1, 20

2012/03, P1, Product1, 30

2012/03, P1, Product2, 50

2012/04, P2, Product3;100

and many other lines for many projects and many months

When i make a chart with Project P1 select, i have all three months

But if i select only product2, i will only see 2012/01 and 2012/03 with no mention of 2012/02

In the chart i could unselect "Suppress zero values" but it seems i would get the 2012/04 month from Project 2 and i don't want that

How can i do ?

I have tried with a master calendar but it doesn't seem to work

And with formulas in the Month dimension, neither

Thanks

christophebrault — Thu, 24 May 2012 11:48:19 GMT

Hi,

The solution is in "Presentation". Uncheck supress missing value and supress null value. Months still appear whereas amout =0.

see attached file

fredericvillemi — Thu, 24 May 2012 12:07:02 GMT

Hi,

i agree about this, that's the basic behaviour

but what i would like when i select a project is to have only the months for any product of this project.

Example : when i select Project1 i should not see month 2012/04

How can i do ?

Thu, 24 May 2012 13:23:35 GMT

Hi Frederic,

may be this expression (and unchecking "show all values") helps you i.e. in a chart with month as dim:

=sum({1 <project=P({$}) > }amount)

Regards, Roland