Storing value in a variable

[#1]

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

[maxgro · Accepted solution]

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

[tresesco]

And if you want to understand it , read :the-magic-of-variables