topic Input box that changes dates in script in QlikView

Input box that changes dates in script

Mon, 19 May 2014 14:02:14 GMT

Hi All,

New to Qlikview and the online community. I am trying to create an input box that changes dates in my script.

My current script....

SET vsAsOfDate=Date#('05/12/2014');
LET vAsOfDate='05/12/2014';

Ideally, I want users to use an input box to enter the date and then reload the script from the UI.

As a side note, the date cannot be a formula because the report is an "as of date". We need the flexibility to pick a point in time.

Thanks,

Mike

whiteline — Mon, 19 May 2014 19:53:17 GMT

Hi.

You can add a variable in qvw user interface and use it for input and setting the variables in script.

venkatg6759 — Mon, 19 May 2014 20:03:38 GMT

Hi Mike ,

Check the below link