Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

12 Replies
Anonymous
Not applicable
Author

try "Show all values" in your day dimension and untick suppress Zerovalues in tab presentation

hariprasadqv
Creator III
Creator III

Hi ,

Un check supress null values or Check Show null values in the chart properties, It may helps you.

prieper
Master II
Master II

as haripradadqv advised and make sure that for each date there is an entry existing in the underlying database

Peter

awhitfield
Partner - Champion
Partner - Champion

If you are actually loading the dates, the un-tick 'suppress missing values' on the presentation tab of the charts properties.

Andy

MK_QSL
MVP
MVP

Check enclosed file..

buzzy996
Master II
Master II

Presentation Ta- Suppress Zero-Values(Uncheck,by default it's selected)

Not applicable
Author

Thank you for your reply,
The problem still persists, since date is spread over 13 months, it's not a month as you have made in your QlikView.
Is there a way to make time for a range of more than a month, example:



MK_QSL
MVP
MVP

Like this?

Not applicable
Author

Thank you very much
it works

Mohssine