topic Re: Variables in QlikView

Variables

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm working on a dashboard and created a table in the visualizations.

I created variables and used them in my table.

If the content of my variable is: round($(vTotal Revenue)/Count(DISTINCT(if([Billing Period] >= Parcel_Signature_Week,([Billing Period]))))*52,1)

I get a different result if the content of my variable is: =round($(vTotal Revenue)/Count(DISTINCT(if([Billing Period] >= Parcel_Signature_Week,([Billing Period]))))*52,1)

The formula itself is correct. The = sign seems to be what causes the difference in results within my table.

Can someone explain why I get 2 different results? Why does adding the equal sign change the output?

Thanks!

Re: Variables

its_anandrjs — Thu, 07 Sep 2017 16:48:34 GMT

Better you can use this expression on variable

round($(vTotal Revenue)/Count(DISTINCT(if([Billing Period] >= Parcel_Signature_Week,([Billing Period]))))*52,1)

and then use variable in expression because when using AGGR key words with expression (SUM,COUNT,AVG...) equals sign by default puts above the expression.

Ex:-

Expression =$(vSum)

Re: Variables

andrei_delta — Fri, 08 Sep 2017 11:29:05 GMT

Hi Cindy,

When you are NOT using the "=" sign when writing a formula in the variable and then you call it in a chart, that's the moment when it gets evaluated.

When Using the "=", the variable already evaluates the expression and gets you a result (and from what i've seen the result is like a total or average of something, depending on your formula) and when you call it in the table it brings you one value for the whole dimension.

I hope it helps!

Re: Variables

Fri, 08 Sep 2017 18:07:36 GMT

Exactly the explanation I was looking for, THANK YOU!!!!!!