topic Retrieve value of an input box in QlikView

Retrieve value of an input box

Fri, 31 Jan 2014 14:16:42 GMT

Hi,

I have an input box with the variable test. The value of this variable is =Date(Today()-1)

Then, in the script, i want to put this variable in a where clause.

Here is my problem, i tried:

Where Column <> $(test)

but it doesn't work because of the '='.

And the thing is that the '=' char is needed in the expression of the variable or it displays 'Date(Today()-1)'

Anyone have an idea for this?

Thanks,

Best Regards,

Loïc

Re: Retrieve value of an input box

Fri, 31 Jan 2014 14:28:39 GMT

Hi Loic!
What's your requirements? will the variable be set by the user? is the value '=Date(Today()-1)' a default value?
Have you tried an If-statement ?

You can try this in your script: where column<> if($test='=Date(Today()-1)'

,Date(Today()-1),$test)

Regards

Re: Retrieve value of an input box

Fri, 31 Jan 2014 14:39:15 GMT

Yes that's right, i just want '=Date(Today()-1)' to be a default value.

I don't know, how do you think i can do this with an If statement?

Re: Retrieve value of an input box

Gysbert_Wassenaar — Fri, 31 Jan 2014 14:42:40 GMT

Just set the variable in the script before you use it in the where clause:

LET vYesterday = num(today()-1);

Test:

Load * from MyTable where MyDate <= $(vYesterday);

Re: Retrieve value of an input box

Fri, 31 Jan 2014 14:49:27 GMT

No guys, this don't work because the users could put another value in the input box and this will not work anymore

Re: Retrieve value of an input box

maxgro — Fri, 31 Jan 2014 15:00:39 GMT

for me Gysbert isolution works

input box (variable test),

today()-1

script

let test2 = $(test);

Table:

LOAD *;

SQL

SELECT *

FROM "sisim_stat".dbo."d003_date"

where dat_data >= $(test2);

Re: Retrieve value of an input box

Fri, 31 Jan 2014 15:06:14 GMT

This is true but the problem with this solution is that the users will see 'Today()-1' instead of '30.01.2014' for today in the input box.

Re: Retrieve value of an input box

maxgro — Fri, 31 Jan 2014 15:17:05 GMT

use a calendar based on the variable test and in number tab choose date

Re: Retrieve value of an input box

Mon, 03 Feb 2014 07:18:35 GMT

How can i use a calendar based on a variable?

Re: Re: Retrieve value of an input box

maxgro — Mon, 03 Feb 2014 08:12:19 GMT

From Menu

R Click on sheet --> New Sheet Object --> Slider/Calendar Object.....-->

In General Tab choose Calendar (Input Style) and Variable(s)