topic Re: How to translate table fields to variables? in QlikView

How to translate table fields to variables?

hugmarcel — Wed, 26 Jun 2013 05:33:51 GMT

Hi

having table:

thetable:

load * inline [

field, formula

a, sum(1)

b, sum(2)

c, sum(3)

];

How can I automaticaly define variables $(a) = sum(1), $(b) = sum(2), $(c) = sum(3) out of thetable in script?

E.g. translate thetable into script statements:

let a = sum(1);

let b = sum(2);

let c = sum(3);

Thx - Marcel

Re: How to translate table fields to variables?

forte — Wed, 26 Jun 2013 05:54:50 GMT

Hi Hugmarcel :

Just try this :

test:

load * inline [

field, formula

a, sum(1)

b, sum(2)

c, sum(3)

];

for i = 1 to NoOfRows('test')

let VariableName = FieldValue('field',$(i));

let Formula = Lookup('formula','field','$(VariableName)','Test');

let $(VariableName) = '$(Formula)';

next

Hope that ir helps.

Best Regards

Re: How to translate table fields to variables?

hugmarcel — Wed, 26 Jun 2013 07:03:43 GMT

ok thx, thats working.

However, I was hoping that I could store the variable definitions into a txt file in the script, and then include back the txt file.

But that's not that easy, because of the header of the (txt) file.

Marcel