topic Loading variable in load script in QlikView

Loading variable in load script

Mon, 09 Apr 2012 07:58:16 GMT

I am writing this expression in the load script to store the value of variable vShare but i am getting error.

let

vShare =avg(aggr(
num(
((sum({$<%EPID={1},Segment={'Stucks'}, TERRITORY=>} (eTRx_Volume))/sum({$<%EPID={7},Segment={'Stucks'},TERRITORY=>} (eTRx_Volume)))-
((sum({$<%EPID={1},Segment={'Stucks'},TERRITORY=>} (eTRx_Volume))-sum({$<%EPID={1},Segment={'Stucks'},TERRITORY=>} (eTRx_Volume_Change))))/
((sum({$<%EPID={7},Segment={'Stucks'},TERRITORY=>} (eTRx_Volume))-sum({$<%EPID={7},Segment={'Stucks'},TERRITORY=>} (eTRx_Volume_Change)))))

,'#,##0.0%'), TERRITORY));

If i write

let

vShare =1; then vShare is storing value 1. but i want to make it dynamic. How can i do it ??

Loading variable in load script

vijay_iitkgp — Mon, 09 Apr 2012 08:04:01 GMT

Hi,

You can not create dynamic variable in Load script. You have to define it in variable overview.

Loading variable in load script

jonathandienst — Mon, 09 Apr 2012 08:27:59 GMT

Let will attempt to evaluate the expression, rather than store it and this expression will not work in the load script.

Change Let to Set to store the expression in vShare.

And yes, I always load complex expressions variables in this way in the load script as they are not stored in the VC system or in an load without data.

Regards

Jonathan