topic Qlikview variables definition - equal vs no equal in QlikView

Qlikview variables definition - equal vs no equal

Fri, 20 Nov 2020 18:02:30 GMT

In Qlikview variables, what is the difference between the following definitions for a variable X -

=SUM(Sales)
SUM(Sales)

Thanks.

Re: Qlikview variables definition - equal vs no equal

chiru_thota — Fri, 28 Mar 2014 23:21:40 GMT

=Sum(Sales) - will be pre calculated as per your selections.

Sum(Sales) - Will be calculated as per chart dimensions and aggregate data accordingly.

Re: Qlikview variables definition - equal vs no equal

Fri, 28 Mar 2014 23:29:28 GMT

I don't understand. Can you please explain what this means -

=Sum(Sales) - will be pre calculated as per your selections.

Sum(Sales) - Will be calculated as per chart dimensions and aggregate data accordingly.

Re: Qlikview variables definition - equal vs no equal

chiru_thota — Fri, 28 Mar 2014 23:42:36 GMT

=Sum(Sales) - will be pre calculated as per your selections.

Data will be aggregated irrespective of your chart dimension.see screenshot

( It aggregated sales for all countries 900)

Sum(Sales) - Will be calculated as per chart dimensions and aggregate data accordingly.

This one is same as writing expression directly in chart.No difference.

Re: Qlikview variables definition - equal vs no equal

simondachstr — Sat, 29 Mar 2014 11:08:15 GMT

Sum(Sales) calculates the sum per row,

=Sum(Sales) is static and calculates the sum of all rows and displays that same result in each row.

Re: Qlikview variables definition - equal vs no equal

swuehl — Sat, 29 Mar 2014 11:17:47 GMT

It's well explained in detail here:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

Re: Qlikview variables definition - equal vs no equal

its_anandrjs — Sat, 29 Mar 2014 12:42:07 GMT

Hi,

=SUM(Sales) if you use this sum script in a chart and a variable it will calculates the sum of each row and display it,

and in variable if you use like

Eg:- Let vSales = SUM(Sales) in this script the value of sales is sum and store in the variable and you can use it in charts also.

SUM(Sales) It is a static script if you use it in and variable it will not sum the value of the Sales in each row but if you use it any chart it will calculates the sum in each row of sales. In variable if you use like

Eg:- Let vSales ='SUM(Sales)'

Hope this helps

Thanks & Regards