Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mklunark
Contributor
Contributor

Date value 0 with Master Calendary

Hi, i have a line chart  with years of date

some year are showing only the month's with values, but the client want to show all the year value, no matter if the value of the year, month or date is 0

This is an exemple of what they want: 

mklunark_0-1654261874795.png

I tryed to criate a master calendary which had some succes but still with some issues on the values 

the new question is, my code is bringing missing values 

if ( IsNull(item), 0, Count ( { < item = { condidion1 } > } item ) )

i don't know how to repair this 

Labels (2)
2 Replies
vinieme12
Champion III
Champion III

You would need to add dummy data in your table with 0 value

and

 then in your chart under AddOn>> Data handling>>check Include zero values 

 

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

i had tryed the master calendary, it work's but not 100%, 

if ( isnull(item), 0, Count ( { < item =  { condition1 } > } item ) )

This code was my try, but had some issues in the count