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: 
Not applicable

Bar chart, display all month days

Hello;
Is there a way to display every day of the month as a dimension of a bar chart in QlikView. Knowing that I get from the database only 2 or 3 days that have values, the other they do not have values, so are not displayed.

this my chart bar :
probleme.JPG
And this is mhat I want :
Solution.png

Note: I tried the continuous option, but it does not work for me. There are side effects.

Thanks

12 Replies
Not applicable
Author

Hi

Check this file

prieper
Master II
Master II

my suggestion attached

Peter

Not applicable
Author

Hi, sorry if I revive this one year old's post

This example seems to work since I have just the "month selector", but if I add another column to the table, like this example:

Load * Inline
[
Date, Sales, Group
01/01/2015, 100, A
03/01/2015, 110, A
06/01/2015, 140, B
10/01/2015, 90, B
14/01/2015, 80, C
16/01/2015, 160, C

];

And then i filter for "Group" how can I display all the days in that month?

Thanks