Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Input box that changes dates in script

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

Tags (2)
2 Replies
whiteline
Honored Contributor II

Re: Input box that changes dates in script

Hi.

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

venkatg6759
Contributor III

Re: Input box that changes dates in script