Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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