topic Re: how to complete missing value pairs in QlikView

how to complete missing value pairs

Thu, 13 Oct 2011 11:44:21 GMT

Hi Community,

can someone give me a hint how I can complete the missing value pairs? Unfortunately, I can't continue the Periode (month), because they are not included in [Periode neu] see image.

At the moment my diagram show only the months that correspond the same field to [Periode] and [Periode_neu].

How can I show the missing months? In addition, should the missing values

be filled with 0.00 like this. See image

As a demonstration you can also to modifiy my attched qvw file.

Thank you very much.

Re: how to complete missing value pairs

swuehl — Thu, 13 Oct 2011 12:16:20 GMT

Hi,

remove the Periode neu from dimensions and use this as expression:

=sum(if([Periode neu] = Periode,[Wert/Bwähr_neu],0))

Please see also attached.

Regards,

Stefan

how to complete missing value pairs

Thu, 13 Oct 2011 12:32:47 GMT

Hi swuehl,

I did not think that it makes a difference between sum(...if () ) and if( sum() ) !

Thank you very much