topic Reusable Expression in variable in QlikView

Reusable Expression in variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Reusable Expression in variable

Anonymous — Mon, 05 Jun 2017 12:58:09 GMT

try

=$(vVariable)

Re: Reusable Expression in variable

Anonymous — Mon, 05 Jun 2017 13:11:43 GMT

Hi Robin,

Thanks for the reply,

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

Re: Reusable Expression in variable

Anonymous — Mon, 05 Jun 2017 13:16:44 GMT

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

Re: Reusable Expression in variable

neelamsaroha157 — Mon, 05 Jun 2017 13:18:02 GMT

Check this out.

Re: Reusable Expression in variable

vicobi123 — Mon, 05 Jun 2017 13:59:36 GMT

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

Re: Reusable Expression in variable

Anonymous — Mon, 05 Jun 2017 14:10:35 GMT

Hi,

Thanks to all it worked ,

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