Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
peisenrot
Contributor III
Contributor III

chart diagram

Hello,

I have a chart diagram with date as x-Axis. After selection of some attributes some the value for some date will come to zero and therefore the date is not showing in the x-axis. can i avoid that and show also date with zero values?

thanks

Pia

 

Labels (3)
1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

Should be working as you can see by my example here.

I have no orders.  Make sure your data handling is set correctly.

ogster1974_0-1675949349553.png

 

View solution in original post

3 Replies
ogster1974
Partner - Master II
Partner - Master II

You need to create a master calendar to link to your fact data.  This will give you the missing dates and the ability to report them as 0.

https://community.qlik.com/t5/QlikView-App-Dev/Creating-A-Master-Calendar/td-p/341286

 

peisenrot
Contributor III
Contributor III
Author

thanks for that hint. I have added the master calendar for this date but 

peisenrot_0-1675948756310.png

as you see I can't see between 3rd and today any data.

 

ogster1974
Partner - Master II
Partner - Master II

Should be working as you can see by my example here.

I have no orders.  Make sure your data handling is set correctly.

ogster1974_0-1675949349553.png