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

Show 0 if there is no data

Heya,

I'm new on Qlikview and have a huge problem:

Our team visits its stores based on their priority A, B and C. I want to show how often they visited each shop e.g. in June (I allready created a master calendar). If a shop hasen't been visited I want to be shown as a "0" in the chart, unfortunatly I do not achieve this ... 😞

(FYI: my data includes only the dates, when a shop was visited)

Can anyone help me?

Regards Veronika

2 Replies
Sokkorn
Master
Master

Hi Veronika,

May be you can play around Null and Missing Symbol. Let right click on chart -> Properties -> Presentation -> Use 0 in "Null Symbol" and "Missing Symbol"

Untitled2.png

Regards,

Sokkorn

Anonymous
Not applicable
Author

You will be required to do 'padding'. I have come across the same situation and I have used John's method to get the missing dates.

Please check these posts.

http://community.qlik.com/message/109672

http://community.qlik.com/message/272081

Regards

MultiView