topic Re: Data Picker Object in Data Movement & Streaming

Data Picker Object

ocharles — Wed, 19 Mar 2025 22:43:16 GMT

I need a way to always default the date picker values to get the First and Last day of any month whether the data is in existence or not.
Example: Month of September 2023

Even if there are no datasets for the beginning of September 2023, I want my filters to always show the full set of dates to display. (09/01/2023 til 09/30/2023)
Concrete Example: Date Selection should always say 09/01/2023 instead of 09/08/2023 indicating that the data was only retrieved beginning 09/08/2023 to 09/30/2023

Re: Data Picker Object

datagrrl — Thu, 26 Oct 2023 19:06:18 GMT

Maybe I am misunderstanding what you are asking, it sounds to me like you might need to create a master calendar.

This is a really old video, but I think it explains the concept.

https://community.qlik.com/t5/QlikView-App-Dev/Creating-A-Master-Calendar/td-p/341286

I have included a script I use for Master Calendars in the attached App. I am not sure what you are saying when referring to "Any Month" but this should help.

Re: Data Picker Object

ocharles — Thu, 26 Oct 2023 19:13:28 GMT

Greetings @datagrrl and thank you for the response you provided. I will bring some clarification to my questions. My Dataset does not include the first day of the month like 09/01/2023 but begins in 09/08/2023 but for my date picker on a dimension called "BilledDate" the dimension doesn't contain the 09/01/2023 dates. And the date picker once I add the "BilledDate" as the dimension gives me the Min (BilledDate) as 09/08/2023 Max(BilledDate) as 09/30/2023. I do not want that default date selection. I want my date selections to always be the first and last date of any month regardless of the dataset in the query for the filled (BilledDate).

Re: Data Picker Object

datagrrl — Thu, 26 Oct 2023 19:34:27 GMT

This post might help you more.

https://community.qlik.com/t5/App-Development/Selecting-Date-range-in-Date-picker-from-last-30-days-till-today/td-p/1876973

If you use this in combination with a master calendar you should get what you need.

The code I put in the value for the sheet action is

= '>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today()))

Specifically this part of the answer should work for you

Using Actions (in sheet properties):

1. select action - Select values matching search criteria

2. Choose your date field

3. Value

= '>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today()))

Re: Data Picker Object

ocharles — Fri, 17 Nov 2023 13:38:02 GMT

Thank you @datagrrl it worked splendidly. Another question if I may. Can you provide an expression that can sum a straight table column and when the user filter the column, the sum changes in a textbox object.