topic Re: InputBox with dropdown selection in QlikView

InputBox with dropdown selection

Tue, 17 May 2011 07:11:13 GMT

my file having "CarrDate" field contains of 30 days of dates .

Now my requirement is i need to use the "CarrDate" field in two InputBoxes with dropdown as StartDate and EndDate.

I.e; StartDate inputbox should have all the 30 days dates but in EndDate inputbox should have >=StartDate.

Ex:

StartDate

01-05-2011

02-05-2011

03-05-2011

04-05-2011

05-05-2011

06-05-2011

07-05-2011

30-05-2011 HINT: If i am selecting 05-05-2011 in StartDate then should start with which is >= current selection,

the EndDate should start from 05-05-2011.(pls see below)

==========================================

EndDate

05-05-2011

06-05-2011

07-05-2011

30-05-2011

Pls share your ideas on this issue.

Thnks

Tue, 17 May 2011 09:04:52 GMT

Hi,

you could use the concat - function to generate the list of possible values for the inputbox.

I.e.you have two variables var1 and var2 and a field called date1:

The list of restricted values for var1 is calculated like this: =concat(Datum, ';', Datum )

and for var2 only dates that are >= var1 are shown: =concat({$<Datum={">=$(Variable1)"}>} Datum, ';', Datum)

I attached a qvw to this post that demonstrate my approach.

I guess that should solve your problem.

Cheers,

Gerald

IAMDV — Tue, 17 May 2011 09:20:02 GMT

Gerald - I love this solution. Thank you very much. I had learnt something new

Cheers - DV