topic Re: Creating Variable in QlikView

Creating Variable

Wed, 25 Nov 2020 16:16:04 GMT

Hiii To All,

I m creating one variable:

LET $LastPrice=Tax+[Unit Price];

M adding Tax and Unit Price but m getting string as it is in my straight table.its not evaluating the expression.

Thanx & Regards,

Qliker.

Re: Creating Variable

MK_QSL — Mon, 04 Jul 2016 10:58:38 GMT

Use

LET LastPrice=Tax+[Unit Price];

Now at front end use $(LastPrice)

Re: Creating Variable

oknotsen — Mon, 04 Jul 2016 10:58:40 GMT

I strongly suggest you not to use the $ sign as part of your variable names. Instead, just start them with v or var.

Anyway,

To "execute" the text, use the dollar function (also known as the dollar-sign-extention or something like that).

Example:

Assumine your variable is called vLastPrice:

$(vLastPrice)

Re: Creating Variable

Chanty4u — Mon, 04 Jul 2016 11:01:44 GMT

missng ' '

LET $LastPrice='Tax+[Unit Price]';

Re: Creating Variable

oknotsen — Mon, 04 Jul 2016 11:04:01 GMT

The quotes should not be needed.

Re: Creating Variable

Mon, 04 Jul 2016 11:12:05 GMT

Problem Solved Guyzz..

Thnx a lot.

But nw i want sum of the variable value m doing Sum($(eLastPrice)).

M getting Double value.

Ex.

My lastPrice= 7.47 but m Getting LastPrice= 14.94

Re: Creating Variable

mangalsk — Mon, 04 Jul 2016 11:26:19 GMT

Please find attached.

just need to $($LastPrice), it worked

Re: Creating Variable

Mon, 04 Jul 2016 11:37:41 GMT

M not able to open your attachment and i have used $($LastPrice) but m not getting the result.

Re: Creating Variable

MK_QSL — Mon, 04 Jul 2016 11:42:05 GMT

Use this expression

=$(=$LastPrice)

Re: Creating Variable

Mon, 04 Jul 2016 11:50:39 GMT

I Have created the variable eLastPrice=Tax+[Unit Price];

now i want the sum of my final value

Sum($(eLastParice)) ????

Re: Creating Variable

MK_QSL — Mon, 04 Jul 2016 12:28:12 GMT

Create Variable as below

eLastPrice=SUM(Tax)+SUM([Unit Price])

now use

=$(eLastPrice)

Re: Creating Variable

Tue, 05 Jul 2016 04:10:02 GMT

I have tried like this bro but again m getting double value.

Re: Creating Variable

Chanty4u — Tue, 05 Jul 2016 05:34:43 GMT

hmmm

The Magic of Dollar Expansions

The Magic of Variables

Re: Creating Variable

mangalsk — Tue, 05 Jul 2016 08:42:47 GMT

Hello,

LOAD * Inline

[

Tax,Unit Price

100,200

];

LET $LastPrice='Tax+[Unit Price]'

This is example script and in chart just do

=$($LastPrice)

Re: Creating Variable

Anil_Babu_Samineni — Tue, 05 Jul 2016 09:17:47 GMT

Omno,

Without quotes how to use LET from scripting?

Re: Creating Variable

Anil_Babu_Samineni — Tue, 05 Jul 2016 09:20:14 GMT

Abhishek,

Simple use your Dimension and create one variable like

LET Sample = 'Gross + Salary';

Then create chart with that dim and use this expression $(Sample)

-- Anil

Re: Creating Variable

Tue, 05 Jul 2016 09:43:16 GMT

M using without quotes nd its working.

Re: Creating Variable

Anil_Babu_Samineni — Tue, 05 Jul 2016 11:15:05 GMT

Check your Variables (Ctrl + alt + v) then see, is that variable in created overthere. If yes, Cool ..