topic Re: Automatically set date picker to date and load data on open sheet in App Development

Automatically set date picker to date and load data on open sheet

Matty — Wed, 31 Jan 2024 04:40:49 GMT

Hi Community,

I am sure this has worked for me before, but now it doesn't for some reason???

I have a date picker and I need it to default to current date and the pivot tables in the model to load the data for the current date only.

I have set a trigger on ActivateSheet and I am using the External to set a variable (vFromDate) that the date picker uses to Today, (I also tried =Date(today())). Here is the thing, the Date Picker is setting the date correctly, and in the correct format and if I expand it, I can clearly see that todays date is selected, but the tables in the sheet is cleared (no data showing). However, if I manually select the date (same as is already selected) the data appears like magic. It's like it has set the date correctly, but is not refreshing to actually load the selected data in the tables.

Just to so there is no confusion. I am not trying to reload the data in the sheet, I just want the selected date (and data) when you open the sheet to be today's date by default. The date picker is setting the date, but not executing the selection until I manually press again on the date that is already selected. Any ideas?

#datepicker

Re: Automatically set date picker to date and load data on open sheet

Anil_Babu_Samineni — Wed, 31 Jan 2024 05:47:48 GMT

@Matty Please check here, Edit Sheet.

Re: Automatically set date picker to date and load data on open sheet

Matty — Wed, 31 Jan 2024 06:27:21 GMT

I am not sure where this is. I am using QlikView ver 11.20.

I can't find this setting, so I assume you are using QlikSense or something else. As I mentioned, the correct date value is selected in the Datepicker, it just does not update the data. Instead it is cleared. I need to select the same value in the Datepicker manually for the data to show in the tables.
In the expressions in the tables I use a syntax similar to this to present the data.

=Sum(if( Date($(vFromDate), 'YYYYMMDD') = date#(LoadDate,'dd/MM/yyyy'), Damaged,0))

Re: Automatically set date picker to date and load data on open sheet

Matty — Wed, 28 Feb 2024 03:32:11 GMT

Ok, I will answer my own question here.

You will need to set the variable used in date picker to

=Num(Today())

Then the sheet will reload automatically onActivate.