Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

farolito20
New Contributor III

select from qvd using macro

how to do a select from qvd table using macro? (vbscript)

4 Replies
martin59
Valued Contributor II

Re: select from qvd using macro

I'm sorry but I don't see the final goal.

Martin Favier

martin59
Valued Contributor II

Re: select from qvd using macro

Can you explain what you want to do ?

Martin Favier

farolito20
New Contributor III

Re: select from qvd using macro

SUB fnConvTC(TCO1,TCD1,cantBase)

LOAD FC as factConv FROM vConversionTC.qvd (qvd) WHERE TCO=TCO1 AND TCD=TCD1;

LET cantReturnTC = IF (TCO1=TCD1,cantBase,cantBase*factConv);

END SUB

I have this sub, but I can't use it in LOAD statement :s So I need write a function using macro..

farolito20
New Contributor III

Re: select from qvd using macro

if you know, please help me!