topic Re: Custom Date Range to display in Bar Chart in QlikView

Custom Date Range to display in Bar Chart

Mon, 26 Jan 2026 18:19:17 GMT

Hello All,

Fairly new to this awesome tool and community.

My data spans 20 years and for a particular chart I would like to only display data for 2016-2019.

My expression is a simple count.

What is the best approach to do this?

As a side, I did manage to create a list box and limiting it to 2016-2019, however, dont know the optimal method to limit the data range in the chart.

Any help much appreciated.

Best.
Sarosh

Re: Custom Date Range to display in Bar Chart

Gysbert_Wassenaar — Mon, 25 Apr 2016 18:07:01 GMT

As a side, I did manage to create a list box and limiting it to 2016-2019, however, dont know the optimal method to limit the data range in the chart.

That's a very good way to do it. It leaves the user free to change the range if necessary.

You can also limit the range in the expressions. Suppose you have a Year field and an expression sum(Forecast). To limit that expression to 2016-2019 you'd change it to sum({<Year={2016,2017,2018,2019}>}Forecast) or to sum({<Year={'>=2016<=2019'}>}Forecast).

Yet another way is to create a bookmark for that selection and then use the bookmark (for example a bookmark with ID BM04) in the expression: sum({BM04}Forecast).

And if you really only need that range and won't use data from the other years in your document at all, then don't load the data from those years. Load only the data you need in the script and filter out the other data with a WHERE clause in the load statement:

MyTable:
LOAD * FROM MySource WHERE Year >= 2016 and Year <=2019;

Re: Custom Date Range to display in Bar Chart

Tue, 26 Apr 2016 00:51:01 GMT

Thank you so much for the detailed response.

Re: Custom Date Range to display in Bar Chart

sreeni_qvd — Tue, 26 Apr 2016 06:02:03 GMT

Hi ,

Please see the below chart expression. using YEAR dimension.

Re: Custom Date Range to display in Bar Chart

Tue, 26 Apr 2016 13:16:07 GMT

Thank you Sreeni! The visual was great.