topic Continuous Date Bar Chart with Null Value Date & Filtered in QlikView

Continuous Date Bar Chart with Null Value Date & Filtered

Fri, 16 Sep 2016 16:41:38 GMT

Is there a combination of setting where you can have a continuous date chart that shows 'gaps' in data (as below)

But when you filter to say year 2015 & 2016, the axis will be limited to 2015 & 2016 but the data gap will still show? I currently can only get to the visual below where the years filtered out are still present in the chart. If I uncheck "Show All Values" on the dimension I lose the data gaps.

Re: Continuous Date Bar Chart with Null Value Date & Filtered

sunny_talwar — Fri, 16 Sep 2016 17:00:21 GMT

Would you be able to share a sample to see the issue?

Re: Continuous Date Bar Chart with Null Value Date & Filtered

Fri, 16 Sep 2016 17:03:51 GMT

The images in the original post show the issue. In the second image I have filtered the data to 2015 and 2016, but there are still 2012-2014 dates in the axis. I do not what these dates show, but I still want Oct 2015 (the month with no data) to still show because it still falls within the filter selection criteria.

Re: Continuous Date Bar Chart with Null Value Date & Filtered

Anil_Babu_Samineni — Fri, 16 Sep 2016 17:21:23 GMT

Use Your Dimension like

Date(Floor(DateField,'MMM-YYYY'))

Date(Date#(DateField,'YourFormat'),'MMM-YYYY')

Re: Continuous Date Bar Chart with Null Value Date & Filtered

Fri, 16 Sep 2016 17:42:33 GMT

Using the expression for FLOOR() displayed only the first few months of 2012 where there was no data. With the second solution my date is already in a date format. I don't see how this would change the axis.

Re: Continuous Date Bar Chart with Null Value Date & Filtered

sunny_talwar — Fri, 16 Sep 2016 17:44:03 GMT

I meant if you can share QVW file?

Re: Continuous Date Bar Chart with Null Value Date & Filtered

Anonymous — Fri, 16 Sep 2016 17:58:01 GMT

Only line chart can keep the data gaps continuity irrespective of period gaps..

If you uncheck show all fields, you can see the selections affected on graph...and to keep the gap ,you should get values with '0' in those periods.