select set of dates in listbox

[#1]

Hi All,

I would like to see set of dates in listbox (Date) get selected up on the selection of list of values of list box(Days).

If possible pls share it with a working example..with the sample data given below.

listbox(Date )        Listbox(Days)

01-01-2015             Past 2 days --- when this get selected it should Select....04-01-2015 & 03-01-2015

02-01-2015             Past 3 days --- when this get selected it should Select....04-01-2015 , 03-01-2015 & 02-01-2015

03-01-2015

04-01-2015

Thanx in advance

Regards

Krishna

[aveeeeeee7en]

Hi

Go through the below threads:

http://community.qlik.com/thread/125400

Regards

Av7eN

[#3]

Hi Av7en,

Thnx for the reply ....Actually I am  looking for a list box selection but not buttons...

Regards

Krishna

[rwunderlich]

Take a look at

Qlikview Cookbook: Date Grouping http://qlikviewcookbook.com/recipes/download-info/date-grouping/

for an example of assigning values like "last 2 days" and "last week" to a listbox.

-Rob

http://masterssummit.com

http://robwunderlich.com

[#5]

Thnx Rob,

It is very informative ....

Regards

Krishna

[timanshu · Accepted solution]

Hi Krishna,

Look for attached file. This works perfectly.

[#7]

Hi Timanshu, This is really awesome....thnq very much..

Regards,

Krishna

[#8]

Hi,

May I know the logic behind this work ? Beacoz, Both the dates and the Duration table has no connection and on what condition it filters? Please explain

Regards

Lathaa

[timanshu]

Hi Lathaa,

It works on the basis of Trigger.  With the help of trigger , we can select any field available in qlikview independent of any linking.

[varunvarma]

Hi Virmani,

Please explain the logic, how  it is working. Thank you.

Regards,

Varma.