Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Qlikview variables, what is the difference between the following definitions for a variable X -
Thanks.
=Sum(Sales) - will be pre calculated as per your selections.
Sum(Sales) - Will be calculated as per chart dimensions and aggregate data accordingly.
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.
=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.
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.
It's well explained in detail here:
http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables
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