topic Re: Variable to QVD in QlikView

Variable to QVD

rash_611 — Wed, 23 Apr 2014 06:54:16 GMT

Hi,

i have a syn. where i need to find the parent call and child calls for each Callnos. So need do some calculation in For Loop having a variable help. but the result of the variable has to be stores in QVD for each callno.

Can any one help on this storing issue.

Regards,

Grace

Re: Variable to QVD

CELAMBARASAN — Wed, 23 Apr 2014 07:03:19 GMT

Create a Table like

VariableResults:

Load 1 AS CallNo, '' AS VarResult Autogenerate 1;

after that assume your variable is vResult

for i=0 to 10

Let vResult = i *30;

Load $(i) AS CallNo, $(vResult) AS VarResult Autogenerate 1; //it will store the callno and varresult to the table called //VaraibleResults

Store VariableResults INTO QVDPATH/VaraibleResults.qvd(qvd);

Re: Variable to QVD

rash_611 — Wed, 23 Apr 2014 07:05:38 GMT

thnks for the reply. but whether it will work for 100 different callnos.

Re: Variable to QVD

CELAMBARASAN — Wed, 23 Apr 2014 07:08:41 GMT

yeah it will work for any number callnos

Re: Variable to QVD

rash_611 — Wed, 23 Apr 2014 09:02:09 GMT

thnks a lot. its working