Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
LOAD * Inline [
Customer, Invoice Number, Amount, Shipment Number
Ralco,562324, 500,1
Ralco,562324, 400,2
Ralco,562324, 200,3
Ralco,562324, 2500,4
Ralco,562324, 5900,5
Ralco,562324, 5800,6
Malco,562, 4500,1
Malco,562, 25400,2
Malco,562, 1200,3
Malco,562, 2500,4
Malco,562, 5900,5
Malco,562, 5800,6
Malco,562, 100,7
Malco,562, 59800,8
];
When I create a bar chart in a direct expression its working fine but when I do this to store in a variable this is not working.
ie I have used the variable in the encircled in the chart, could you please suggest me where I am making a mistake.
Regards
define variable as
sum({1} Amount)
not as
=sum({1} Amount)
here for detail
http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables
define variable as
sum({1} Amount)
not as
=sum({1} Amount)
here for detail
http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables
And if you want to understand it , read :the-magic-of-variables