Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
onkarkulkarni
Creator
Creator

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

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...

     

4 Replies
tresesco
MVP
MVP

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.

Kushal_Chawda

try to implement the script logic. refer to below link

From Date & To Date Selection Script Solution

ahaahaaha
Partner - Master
Partner - Master

Hi,

May be like as attached file?

Regards,

Andrey

onkarkulkarni
Creator
Creator
Author

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.