topic Re: Difference between $(Variable) and $(=Variable) in QlikView

Difference between $(Variable) and $(=Variable)

kushalthakral — Mon, 08 Feb 2016 11:19:00 GMT

Hi All

Just wanted to know what is the difference between $(Variable) and $(=Variable) while using them in Set Analysis

Thanks

Kushal Thakral

Re: Difference between $(Variable) and $(=Variable)

marcus_sommer — Mon, 08 Feb 2016 11:34:52 GMT

Variable: 1+2

$(Variable) returned 1+2

$(=Variable) returned 3

The Magic of Dollar Expansions

- Marcus

Re: Difference between $(Variable) and $(=Variable)

kushalthakral — Mon, 08 Feb 2016 11:38:39 GMT

Hi Marcus

I have checked if you use =$(Variable) in a text object or =$(=Variable), both are giving same result

i have defined Variable value 1+2 in variable overview.

Regards

Kushal Thakral

Re: Difference between $(Variable) and $(=Variable)

vikasmahajan — Mon, 08 Feb 2016 11:43:32 GMT

PFA document

Vikas

Re: Difference between $(Variable) and $(=Variable)

swuehl — Mon, 08 Feb 2016 11:44:58 GMT

Have also a look at

The Little Equals Sign

and the comments below this blog post.

I think the example using simple arithmetic is also not the best example, compare an aggregation like Max(Date) put into a variable and expanded in e.g. a chart dimensional context.

Re: Difference between $(Variable) and $(=Variable)

marcus_sommer — Mon, 08 Feb 2016 11:45:57 GMT

In this simple case it looked identically - but it isn't. The difference here is where the variable-content will be evaluated. By $(=Variable) is it inside from the $-sign expansion and $(Variable) will be evaluated within the field respectively expression in which it is embedded.

The best explanation will you find within the link above and here: The Magic of Variables.

- Marcus

Re: Difference between $(Variable) and $(=Variable)

jonathandienst — Mon, 08 Feb 2016 11:56:25 GMT

Simply put the difference is where the expression is evaluated:

$(Variable)

returns the expanded variable, which may then be evaluated by the expression. May be evaluated many times in a table.

$(=Variable)

evaluates the expression in the variable, and the value is returned. Evaluated once in a table or chart.

It is similar to the difference between a variable defined without a leading equals sign, or with a leading equals sign

EDIT - beaten to the punch by Marcus.

Re: Difference between $(Variable) and $(=Variable)

kushalthakral — Mon, 08 Feb 2016 12:03:08 GMT

Thank You All for your replies.

Regards

Kushal Thakral

Re: Difference between $(Variable) and $(=Variable)

alsale_1968 — Mon, 08 Feb 2016 14:15:07 GMT

Hi,

Thanks. It has been very useful to me.

Re: Difference between $(Variable) and $(=Variable)

ayandey18 — Fri, 01 Feb 2019 12:50:24 GMT

Can anybody explain how the following expression perform on the run-time

vCompare = $(=If($(vTYMTDSales) - $(vLYMTDSales) > 0,0,1))

vCompare = =If($(vTYMTDSales) - $(vLYMTDSales) > 0,0,1)

Re: Difference between $(Variable) and $(=Variable)

ramonarcusa36 — Tue, 05 Mar 2019 08:40:19 GMT

Hi you all.

I find interesting what you say here, especially the part in which you say that the second approach makes the expression to be evaluated just once. That suggests we should do it that way, as far as performance is concerned.

I did a little testing. If the $(=variable) will make the variable to be evaluated first and then return its value to the expression, I guessed I would find differences if I do this:

MyVar: sum(Kilos) + sum(Euros)

Then I create a straight table with these two expressions:

Expression 1: $(MyVar) / 100

Expression 2: $(=MyVar) / 100

I would expect different results, since the first one should just expand the content of the variable and hence do something like sum(Kilos) + Sum(Euros) / 100 (for example 10 + 200 / 100 = 12), and the second one should calculate the sum first resulting in something like (10 + 200) / 100 = 2,1.

But the thing is both approaches behave the same way. It seems like both are expanding the content of the variable and doing something like 10 + 200 / 10 = 12. I never get the sum evaluated first.

Please see attached document.