Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating Variable

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.

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

17 Replies
MK_QSL
MVP
MVP

Use

LET LastPrice=Tax+[Unit Price];


Now at front end use $(LastPrice)

oknotsen
Master III
Master III

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)

May you live in interesting times!
Chanty4u
MVP
MVP

missng  ' '

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

oknotsen
Master III
Master III

The quotes should not be needed.

May you live in interesting times!
Not applicable
Author

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

mangalsk
Creator III
Creator III

Please find attached.

just need to $($LastPrice), it worked

Not applicable
Author

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

MK_QSL
MVP
MVP

Use this expression

=$(=$LastPrice)

Not applicable
Author

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

now i want the sum of my final value

Sum($(eLastParice)) ????