topic How to input multiple dates into a variable in QlikView

How to input multiple dates into a variable

Tue, 16 Aug 2011 19:13:20 GMT

Hi,

We have two list boxes with weekends. user wants to select 4 weekends for calendar1 for example(07/03,07/10,07/17,07/24) and 4 weeknds from the calendar2 and want to compare the sales amount.

thank you

How to input multiple dates into a variable

rahulgupta — Wed, 17 Aug 2011 04:12:32 GMT

Use this:

vCalender1=getfieldselections(<fieldname1>,',')

vCalender2=getfieldselections(<fieldname2>,',')

Now in Expression:

Sum({<fieldname1={'$(vCalender1)'}>}Sales)

Re: How to input multiple dates into a variable

Wed, 17 Aug 2011 18:52:25 GMT

thank yu Rahul. the variable part works well. but the sum amount is not .May be i am missing something.iam attaching the file.

How to input multiple dates into a variable

rahulgupta — Thu, 18 Aug 2011 06:02:54 GMT

Hi!

I checked the file...the amount for weekend1 and for weekend2 are coming same that is y there difference is coming 0. so data is not being displayed in the chart.

How to input multiple dates into a variable

Thu, 18 Aug 2011 13:40:32 GMT

its not picking the different weekends form the list box.Ex. if we select week A and B in first listbox and Week C and D in the second listbox .its picking the same weekend in both the list boxes.

thank yu for yu help.