topic Re: Storing value in a variable in QlikView

Storing value in a variable

Fri, 04 Jul 2014 10:23:38 GMT

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 — Fri, 04 Jul 2014 12:20:29 GMT

define variable as

sum({1} Amount)

not as

=sum({1} Amount)

here for detail

tresB — Fri, 04 Jul 2014 12:25:46 GMT

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