topic Re: Need to reset date variable based on the selection in bar chart in QlikView

Need to reset date variable based on the selection in bar chart

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

Hello all,

I have an onboarding date column in my data. In order to display start date & End date in calendar view I have used triggers (Document properties). Its working fine. Start date and End date only shows first and last date they are not dynamic based on other selections in listbox and charts.

If I use Onboarding date as is in Listbox, its shows dates associated to selected bar in bar chart

When I click on particular bar in chart rest of list box like 'Country', 'Region' shows associated values. I want same to reflect in start date & End Date.

How can I do that? Hope my question is clear...

Re: Need to reset date variable based on the selection in bar chart

tresB — Tue, 08 Aug 2017 06:34:09 GMT

May be using min max values to the variables like Max([Onboarding Date]) and Min([Onboarding Date]). If you could share a sample qvw of yours, we can work upon that.

Re: Need to reset date variable based on the selection in bar chart

Kushal_Chawda — Tue, 08 Aug 2017 06:52:58 GMT

try to implement the script logic. refer to below link

From Date & To Date Selection Script Solution

Re: Need to reset date variable based on the selection in bar chart

ahaahaaha — Tue, 08 Aug 2017 08:13:21 GMT

Hi,

May be like as attached file?

Regards,

Andrey

Re: Need to reset date variable based on the selection in bar chart

onkarkulkarni — Tue, 08 Aug 2017 11:05:21 GMT

Thanks a lot for your inputs.. while creating a sample qvw for your reference I found the solution. I set my start date and end variable whenever there is change in Country, Region. It is working as per the expectation.

Thanks again for your anticipation.