topic option for user input when reloading script in QlikView

option for user input when reloading script

Wed, 14 Jul 2010 18:41:36 GMT

Hi,

I have the following load script and im wondering if there is a way for the user to input a date in somekind of input box which can be used for the load script?

Below is my current script and i would like the input (date in bold) to be used when a reload is required.

-----------------

LOAD [Sort Date],
'12/07/2010' - [Sort Date] as [Days Outstanding],
DATTYP_ID,
TRX_DAT,
TRX_ID AS [Transaction ID]
FROM
data\TRANSACTION_DATES.qvd
(qvd);

-----------------

It would also be nice if a button was available that upon clicking will ask the user to input a date and then commence reloading the script.

Any help would be great.

Regards

Jason

option for user input when reloading script

Wed, 14 Jul 2010 19:05:36 GMT

I got the the input box to work but i now get the following error:

Field not found - <ReportStartDate>

My script is below

------------

let rDate=Input('Enter Report Date (format DD/MM/YYYY', 'Input box');
LOAD [Sort Date],
ReportStartDate - [Sort Date] as [Days Outstanding],
DATTYP_ID,
TRX_DAT,
TRX_ID AS [Transaction ID]
FROM data\TRANSACTION_DATES.qvd(qvd)
Where ReportStartDate=$(rDate);

-----------------

Any help would be great.

Thanks

Jason

option for user input when reloading script

pablolabbe — Wed, 14 Jul 2010 20:18:51 GMT

Jason,

First create the variable ReportStartDate and initialize it in your script. Then you can use the variable in an input box.

Cheers,

Pablo

option for user input when reloading script

Wed, 14 Jul 2010 20:33:46 GMT

hi thanks for your advise, im not sure how to create the variable.

what should my script look like if i wanted to do this?

kind regards

jason

option for user input when reloading script

rwunderlich — Thu, 15 Jul 2010 05:06:45 GMT

Jason,

You will need to assign the Input() value to ReportStartDate like this:

let ReportStartDate = Input('Enter Report Date (format DD/MM/YYYY', 'Input box');

And then convert the input text value to a date value in your expression like this:

LOAD Date#('$(ReportStartDate)') - [Sort Date] as [Days Outstanding], etc

-Rob

option for user input when reloading script

Thu, 15 Jul 2010 09:24:41 GMT

Many thanks Rob this worked just fine.

option for user input when reloading script

Thu, 15 Jul 2010 12:13:26 GMT

Does anyone know how to add a default value to an user input box.

I have the following input box:

let ReportStartDate = Input('Enter Report Date (format DD/MM/YYYY', 'Input box');

And i want by default this to display todays date. The user has the option to change the default 'todays date' or enter a date of their own.

Regards

Jason