topic Re: Show only today and older on X-axis of Line chart (exclude future dates)? in QlikView

Show only today and older on X-axis of Line chart (exclude future dates)?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a chart where I am tracking sales by [DateBusinessDay]. However, it is currently showing every day, including future days, for the month but I wish to show only today and previous days for the month. The future dates with no sales yet just makes the chart "too busy" and does not really add any value seeing those future dates blank.

Is there a condition or something I can put in place to show only dates of today and older for my chart?

Thanks.

Re: Show only today and older on X-axis of Line chart (exclude future dates)?

vishsaggi — Wed, 13 Jul 2016 21:17:29 GMT

I am not sure, I have not tried, but may be you can use the expression like in the image below in Axes tab of chart properties. Dimension axis, check continuous and set date field static min and static max.

Re: Show only today and older on X-axis of Line chart (exclude future dates)?

swuehl — Wed, 13 Jul 2016 21:34:01 GMT

The conditional enablement of the dimension is evaluated once per chart, I believe this is not what you want.

You can create a calculated dimension, like

=If( DateBusinessDay <= Today(), DateBusinessday)

[and enable 'Suppress When Value is NULL' on dimension tab]

or use set analysis in all your expression's aggregation functions to filter your dimension.

Re: Show only today and older on X-axis of Line chart (exclude future dates)?

Thu, 14 Jul 2016 01:48:34 GMT

thank you, this seems to be working