topic Re: Start Date and Todate in QlikView

Start Date and Todate

ravindraa — Mon, 12 Sep 2016 08:56:44 GMT

Hi All,

I have strcuk in one place please give me any suggestion to come out of this place.

My requirement is i have to put two input boxes to select the dates i mean one input box for START DATE and one for TODATE.

for that i have created two variables i am trying to pass two date fields but the values are not changing according to the date selection.

ex:

in Start date input box i passed 1/14/2016 and

in TOINPUTBOX i passed 1/20/2016

Now i want to display the date from Jan 14 to jan 20 but the values are not changing.

kindly give me any suggestion.

Please find the attached document.

sunny_talwar — Mon, 12 Sep 2016 09:02:00 GMT

May be a trigger on your both the variables with the following search string:

='>=' & Startdate & '<=' & Todate

Anonymous — Mon, 12 Sep 2016 09:05:31 GMT

you may chnage your listbox with date to a listbox with expression

=if (Date>='$(Startdate)' and Date<='$(Todate)',Date)

sasikanth — Mon, 12 Sep 2016 10:57:46 GMT

HI Ravindara,

As an alternative you can use calendars here,

Please find the attached application.

Hope it helps you.