Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

InputBox with dropdown selection

Hi

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

Tags (1)
2 Replies
Not applicable

Re: InputBox with dropdown selection

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
Honored Contributor II

Re: InputBox with dropdown selection

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

Cheers - DV

Community Browser