Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

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)) ????