topic Re: Clear All in Date Picker in QlikView

Clear All in Date Picker

Tue, 20 Jun 2017 11:08:19 GMT

I have a date picker in my app which the user can select the to and from dates. This date picker is copied onto the 4 other tabs too so the user can change the dates if required in the different tabs.

I would like it when the user moves to another tab that the date picker dates clear.

I have a field called DATE and two variables VStartDate and vEndDate

The variables have just dates in them in variable overview. Well the date number e.g. 42375

The date picker start date has a min value of =date(min({1}date),'dd/mm/yyyy') in it and the max value of =vEndDate

The date picker end date has a min value of =VStartDate and max value of =date(max({1}date),'dd/mm/yyyy')

I have tried an action to clear the fields but it isn't working

Does anyone have an idea of how to rest these fields

Thanks

Re: Clear All in Date Picker

prat1507 — Tue, 20 Jun 2017 11:15:04 GMT

Change the variable values while switching to other tabs.

Regards

Pratyush

Re: Clear All in Date Picker

sunny_talwar — Tue, 20 Jun 2017 11:15:14 GMT

Not sure how all of this is setup... would you be able to share a sample where you are doing this?

Re: Clear All in Date Picker

RonaldDoes — Tue, 20 Jun 2017 11:19:17 GMT

You could have a trigger OnActivateSheet to set variable vStartDate to Null() and vEndDate to Null().

This would clear your datepickers. However, it appears to me to be counterintuitive, depending on dashboard design.

Re: Clear All in Date Picker

Tue, 20 Jun 2017 13:23:16 GMT

How could I do this? Would it be through Select in Field option? How can I set this to null? Thanks

Re: Clear All in Date Picker

sunny_talwar — Tue, 20 Jun 2017 13:28:55 GMT

You can use Set Variable action within External action type to set variable value to null

Re: Clear All in Date Picker

RonaldDoes — Tue, 20 Jun 2017 13:57:30 GMT

Hi Sarah,

As usual, stalwar1‌ beat me to it

His suggestion below is the one I had in mind for you. Open the sheet properties by clicking CTRL+ALT+S and go to tab Triggers. Just add the variable names and =Null() to the respective fields.