MTD in list box

[abhijith28]

Hi,

Please someone help on this scenario

i have a date field of 15 years data, suppose if i select a date in list box, it must select from the date i selected to past 15 days date.

ex: If i select 30/01/2019, it has to select 15/01/2019 to 30/01/2019.

Thanks for your help.

[dplr-rn]

can you please elaborate what you mean by 'select  15/01/2019 to 30/01/2019'

If you want the data to shown in a chart you will need to use set analysis. i can elaborate if needed.

if you mean select dates as a filter i think you will need to put the date you are doing the selection as an island table and use trigers to select the appropriate date fields

[Sue_Macaluso]

Is this for QlikView or Qlik Sense? Id' like to move it over to the appropriate product forum. This forum is for general discussion.

[abhijith28]

Ex: I have a date field, i.e. [Birthdate]

in List box i will choose [Birthdate], this Birthdate field contains dates values from 01/01/2010  to 09/02/2019.

Suppose if i select the date 30/01/2019 from this List box.

The output should be : In list box, the date from 15/01/2019 to 30/01/2019 has to selected. i.e. previous 15 days date to selected date.

[abhijith28]

This is for both Qlikview and Qlik sense..scripting level