topic Variable in QlikView

Variable

Tue, 25 Nov 2014 07:58:55 GMT

Is it possible to create a variable in the script and assign the respective value in the front end .

Thanking You

Vinayagam

Re: Variable

anbu1984 — Tue, 25 Nov 2014 08:01:35 GMT

Yes. Check this link

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/01/loading-data-into-input-boxes

Re: Variable

alexandros17 — Tue, 25 Nov 2014 08:08:54 GMT

yes

try this:

LET myVar = 100;

... in the front end you can use fo example

Sum({$ <myField={$(myVar)}>}myVal)

Re: Variable

prodanov — Tue, 25 Nov 2014 08:10:15 GMT

Hi,

Of course, you can. All variables, which you create in the process of loading are available in layout and the all variables, which you create in layout are available in the script.

Regards

Dimitar

Re: Variable

sujeetsingh — Tue, 25 Nov 2014 08:11:37 GMT

Yes you can. But why to do this you can create one from Variable in document properties and set and event/action in UI to update its value.

Re: Variable

jagan — Tue, 25 Nov 2014 08:12:20 GMT

Hi,

check this link

http://community.qlik.com/blogs/qlikviewdesignblog/2014/11/24/the-equal-sign

Hope it helps you.

Regards,

Jagan.

Re: Variable

Nagaraju_KCS — Tue, 25 Nov 2014 08:15:31 GMT

Hi Vinay,

We can do both sdies (Scripting and Designing)

we have 2 types of variables SET and LET

Using SET you are adding string value to a variable
SET Variable1='4+5';
returns variable value is= '4+5'

using LET you are adding an expression result to a variable
LET Variable1=4+5;
returns variable value is= 9

Hope you understand..................

Re: Variable

its_anandrjs — Tue, 25 Nov 2014 08:32:28 GMT

Hi,

Yes and in front end you can assign the value to variable by the help of the input box.

In Script

Let xVar = 0;

In front end by input box enter any value by using this variable.

Or you can check Henric Explanation

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

Regards,

Anand

Re: Variable

ashfaq_haseeb — Tue, 25 Nov 2014 09:28:23 GMT

Hi,

Check this for better understanding.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/18/dollar-expansions

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

Regards

ASHFAQ

Re: Variable

Tue, 25 Nov 2014 13:30:24 GMT

Thank you All for the instance reply

But is it possible to do it in the below mentioned way

Let Vest=0;

Load

Date1,

Amt,

Date2(Vest)

From ,,,,,,

And the pass the value to the variable using calendar object;