topic Re: select from qvd using macro in QlikView

select from qvd using macro

farolito20 — Fri, 11 Jan 2013 17:04:41 GMT

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

martin59 — Fri, 11 Jan 2013 17:06:11 GMT

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

Martin Favier

martin59 — Fri, 11 Jan 2013 17:06:34 GMT

Can you explain what you want to do ?

Martin Favier

farolito20 — Fri, 11 Jan 2013 17:09:47 GMT

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 — Fri, 11 Jan 2013 17:20:24 GMT

if you know, please help me!