topic Weird behaviour when using variables in chart expressions in QlikView

Weird behaviour when using variables in chart expressions

Wed, 25 Nov 2020 16:16:04 GMT

I have an expression thtat is repeated a lot in my document and it is the following:

=sum({$<[Type] = {'type_A'}>}if(duration > 0.0, 1,0))

so I put it into a variable called totalbreakdown.

If I use that variable for one of my expressions in the chart (tab expressions) and I assign the variable to it in field definition as below:

totalbreakdown

then I do not get the same result in chart that if I put the complete expression in the field definition:

=sum({$<[Type] = {'type_A'}>}if(duration > 0.0, 1,0))

So why¿?

Re: Weird behaviour when using variables in chart expressions

migueldelval — Fri, 22 Jul 2016 09:26:09 GMT

Hi Tony,

Try with this.

=sum({$<[Type] = {'type_A'}>}if(duration > 0.0, duration,0))

You need to change 1 fort your measure, because 1 only express that you want to show something, but aren´t using any measure.

Regards

Miguel del Valle

Re: Weird behaviour when using variables in chart expressions

swuehl — Fri, 22 Jul 2016 09:37:12 GMT

The result might be depending on the way you are defining your variables and how you call them:

The Magic of Variables

The Little Equals Sign

Re: Weird behaviour when using variables in chart expressions

Fri, 22 Jul 2016 10:46:34 GMT

Hi, Miguel,

With this expression I am trying to get the number of tuples of type "Type_A" which have a duration value greater than 0.0 so no need to change 1 by duration. Changing by duration you are obtaining the sum of all duration that complains duration > 0.0 and this is not what I want. Anyway my problem is that my chart is displaying different values depending on the value I assign to one of the expressions, if I assign the variable it displays a result that is different from the result that is displayed when I put the variable content directly.

Thanks in advance!