Dynamic previous day filter for table box

abc_18 — Fri, 10 Feb 2023 07:15:11 GMT

Hi,

My application has two filters: current date and previous date.

When a user selects a date, such as today, in previous date the value is -1 and display it in the table box.

Now the requirement is the previous date must be dynamic, which implies that it must default to the current date-1 while still allowing users to pick any other previous dates concurrently.

Re: Dynamic previous day filter for table box

edwin — Tue, 21 Feb 2023 18:48:58 GMT

if i understand it correcty, you have 2 fields CURRENT DATE and PREVIOUS DATE. what you want is when the user selects CURRENT DATE, you want PREVIOUS DATE to default to CURRENT DATE -1.

Are you using Qlikview? if so, add a field event on CURRENT DATE when selected, select PREVIOUS DATE

if you are using QLik Sense, unfortunately, there are no triggers that will select a 2nd field when you select any field. however, you can associate CURRENT DATE to all PREVIOUS DATEs that are <CURRENT DATE. meaning, all dates prior to CURRENT DATE are now selectable. then create a variable that gets the date(max(PREVIOUS DATE)) and use that in your calculation as set analysis modifier. this means CURRENT DATE -1 becomes the default should no selection for PREVIOUS DATE be made. the user can then select any PREVIOUS DATE and since max(of the selected PREVIOUS DATE) = selected PREVIOUS DATE then it gets inserted into your calculation

vPreviousDateDefault = date(max([PREVIOUS DATE]))

your expression will need the set analysis modifier

{<[PREVIOUS DATE]={'$(vPreviousDateDefault )'}>}

topic Dynamic previous day filter for table box in QlikView

Dynamic previous day filter for table box

Re: Dynamic previous day filter for table box