topic Re: In Script Take result of variable and put into a field then output to QVD in QlikView

In Script Take result of variable and put into a field then output to QVD

oakes_gco_qlik — Wed, 11 May 2016 11:50:50 GMT

I have a variable(vVAR01) which contains a calculation Example (=FieldA + FieldB). In the script I want to take the RESULT of this variable (FIELDA = 2 FIELDB = 3) Result = 5 and put it into a Field which can be output to a QVD.? ie output the contents of result.

Re: In Script Take result of variable and put into a field then output to QVD

settu_periasamy — Wed, 11 May 2016 18:29:33 GMT

May be like this.?

Let A=5;
Let B=10;
Let Result=A+B;
Let Result1=A*B;

New:
LOAD '$(Result)' as Result,'$(Result1)' as Result1 Inline [
Temp
''
];

STORE New into Variable_store.qvd(qvd);

Re: In Script Take result of variable and put into a field then output to QVD

oakes_gco_qlik — Thu, 12 May 2016 12:54:01 GMT

My original variable contents was = (C2/C1*100) Using your logic my result was '=(C2/C1*100)'

where as I was requiring the value 97.5564

I have now found that you can use the 'EVALUATE' function EG

Evaluate ($(vSR283)) AS Result

Where the variable is loaded via a spreadsheet and contains the above code. (C2/C1*100)