topic Bar Chart with Specific date ranges in QlikView

Bar Chart with Specific date ranges

ZoeM — Wed, 25 Nov 2020 16:16:04 GMT

Hello Community.

I am looking to create a chart with a dynamic range of dates.

All of my dates are coming into the dashboard through a date bridge and I have to use a date key to specify which range I am referring to when I create a chart e.g Date_Type={'VPP Date"}

Now I need to create a chart that will track the progression of sales between Date_Type={'Start Date'} and Date_Type={'VPP Date'}.

How can I build this? And I am assuming this will be a dimension?

Thanks in advance...

Zoe M.

Re: Bar Chart with Specific date ranges

neelamsaroha157 — Thu, 26 Jul 2018 20:51:22 GMT

You can use your date field in the dimension as it is and use set analysis in the expression with the specified range which will automatically limit the the date range in the dimension.

Re: Bar Chart with Specific date ranges

ZoeM — Thu, 26 Jul 2018 20:57:53 GMT

Thanks Naleem. That worked, however, I am only seeing the Start Date and the VPP Date. How can I show all dates in-between?

The 'Show All Values' checkbox is grayed out under dimensions.

Re: Bar Chart with Specific date ranges

neelamsaroha157 — Fri, 27 Jul 2018 12:39:27 GMT

Can you share a sample.