topic How to implement drop down in QlikView

How to implement drop down

sunil1989 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I am new to qlik.

Thanks in advance.

in my current table on open have to show from today() to future 21 days data ,

there will be drop down box in that i have to show last 7 days date (today() - 7 date ) , whenever the user will select date from drop down

the table should shows data from selected date to (selected date+ 21 days) data.

can any one suggest how this can be implemented !!!!!.

Thanks,

Sunilkumar

Re: How to implement drop down

Peter_Cammaert — Fri, 07 Apr 2017 08:14:57 GMT

First and during reload, create a calendar. Connect the data in your data model to the field that conatins dates. Lets's call that field CalDate.

Then make a list box with an expression like (shows today and previous six (6) days):

=IF(CalDate > Floor(Today())-7, CalDate)

Since the listbox will show a maximum of 7 dayes, there is no need to turn it into a dropdown object as this is usually too much layout work. If you really want to create a dropdown, you'll have to assemble one using buttons and a listbox that is conditionally shown.