topic Re: Bar chart, display all month days in QlikView

Bar chart, display all month days

Fri, 20 Nov 2020 18:02:30 GMT

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 :

And this is mhat I want :

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

Thanks

Re: Bar chart, display all month days

Anonymous — Fri, 27 Mar 2015 11:14:51 GMT

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

Re: Bar chart, display all month days

hariprasadqv — Fri, 27 Mar 2015 11:15:40 GMT

Hi ,

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

Re: Bar chart, display all month days

prieper — Fri, 27 Mar 2015 11:21:02 GMT

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

Peter

Re: Bar chart, display all month days

awhitfield — Fri, 27 Mar 2015 11:22:33 GMT

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

Andy

Re: Bar chart, display all month days

MK_QSL — Fri, 27 Mar 2015 11:50:36 GMT

Check enclosed file..

Re: Bar chart, display all month days

buzzy996 — Fri, 27 Mar 2015 12:44:59 GMT

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

Re: Bar chart, display all month days

Fri, 27 Mar 2015 13:50:22 GMT

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:

Re: Bar chart, display all month days

MK_QSL — Fri, 27 Mar 2015 13:52:58 GMT

Like this?

Re: Bar chart, display all month days

Fri, 27 Mar 2015 14:09:20 GMT

Thank you very much
it works

Mohssine

Re: Bar chart, display all month days

Fri, 27 Mar 2015 14:14:35 GMT

Check this file

Re: Bar chart, display all month days

prieper — Fri, 27 Mar 2015 14:23:49 GMT

my suggestion attached

Peter

Re: Bar chart, display all month days

Mon, 21 Mar 2016 13:14:06 GMT

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