Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewsam
Creator
Creator

Reusable Expression in variable

Hi Al,

Please let me know how to use reusable expression in variable.

Example

LOAD * INLINE [
Country, Sales, Region , Year
A, 10, A1, 2017
B, 20, B1, 2017
C, 30, C1, 2017
A, 101, A1, 2016
B, 201, B1, 2016
C, 301, C1, 2016

]
;

I used Sum(Sales) in variable (vVariable) , but I am getting the result like the below one

Expression : =vVariable

1 Solution

Accepted Solutions
Anonymous
Not applicable

for me it works, have a look at the attachment...

View solution in original post

6 Replies
Anonymous
Not applicable

try

=$(vVariable)

qlikviewsam
Creator
Creator
Author

Hi Robin,

Thanks for the reply,

I am getting the same result if I use $(vVariable)

Anonymous
Not applicable

for me it works, have a look at the attachment...

View solution in original post

neelamsaroha157
Specialist II
Specialist II

Check this out.

vicobi123
Contributor III
Contributor III

If it's not $(vVariable), then it's something to do with your joins in your data model

qlikviewsam
Creator
Creator
Author

Hi,

Thanks to all it worked ,

The mistake i did is =sum(Sales) in vVariable , it should be sum(Sales)