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: 
amien
Specialist
Specialist

show all dimensions in bart chart, even when value = 0 or Null

I have a bar chart in sense. When i select a specific client, i want to see all months in my bar chart, not only the months where the client bought something. So i should see this

jan : 50

feb : 60

mrt : 0

Apr : 0

May : 10

etc

How can i do this? I have linked a full master Calendar.

I dont want to add 0 values to the fact table, because i have to do this for every possible dimension

any ideas? i tried all check boxes available

Thanks in advanced

1 Solution

Accepted Solutions
sunny_talwar

May be this:

+ Avg({1<[Year]={$(=Max([Year]))}>} 0)

View solution in original post

4 Replies
sunny_talwar

Can you tried adding + Avg({1} 0) to your expression? If that doesn't work, would you be able to provide a sample?

amien
Specialist
Specialist
Author

That worked Sunny .. briliant.. only one more question.

This give me all years .. i only want to see the current selected year or max year

i dont see where to put this .. something like this :

{<[Year]={$(=Max([Year))}>}

sunny_talwar

May be this:

+ Avg({1<[Year]={$(=Max([Year]))}>} 0)

amien
Specialist
Specialist
Author

Thanks again Sunny!