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: 
Vasiliy_Beshentsev
Creator III
Creator III

How to view all month?

Hello, everyone!

So what i need to do to see all 12 months in my graph even with zero or null measures??

2017-02-17 12_51_51-Controlling_new(1) _ Листы - Qlik Sense.png

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

OK, I think you are using the year month field from your fact table and those missing months don't exist in your FACT table.

Use the year month field from your Master Calendar that relates to your fact, the same approach will work

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

14 Replies
Chanty4u
MVP
MVP

Did you checked show null values option in Add on's tab

Vasiliy_Beshentsev
Creator III
Creator III
Author

2017-02-17 12_59_48-Controlling_new(1) _ Листы - Qlik Sense.png

Chanty4u
MVP
MVP

try this in front end

in dimension

=Month(YearMonth)

vinieme12
Champion III
Champion III

Change your Expression to show something other than 0; so suppress zero doesn't take effect

= if(sum(Expression)=0,0.0001,sum(Expression))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Vasiliy_Beshentsev
Creator III
Creator III
Author

Result:

2017-02-17 13_23_32-Controlling_new(1) _ Листы - Qlik Sense.png

Vasiliy_Beshentsev
Creator III
Creator III
Author

What is YearMonth?

vinieme12
Champion III
Champion III

OK, I think you are using the year month field from your fact table and those missing months don't exist in your FACT table.

Use the year month field from your Master Calendar that relates to your fact, the same approach will work

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Chanty4u
MVP
MVP

okay. try with  Synthetic dimensions  create variable for months and use that in value list.. like below

“=if(ValueList($(VarMonths…”

Vasiliy_Beshentsev
Creator III
Creator III
Author

So there is no way to show up all months without using master calendar???

It's so sad... I prepared to use this in very last moment...