Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to complete missing value pairs

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.

compare1.JPG

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

compare2.JPG

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

Thank you very much.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

Not applicable
Author

Hi swuehl,

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

Thank you very much