topic Re: Mapping - ApplyMap in QlikView

Mapping - ApplyMap

farolito20 — Fri, 11 Jan 2013 15:18:58 GMT

I have this Mapping Table..

fbFetCosecha:

Mapping LOAD t_fdat,

t_edat,

t_gpci,

codCosecha

FROM TablafnGetCosecha.qvd (qvd);

And I need applymap in load.

I have 2 fiels, and I need codCosecha

I have this codition to applymap:

-date between t_fdat and t_edat

-group = t_gpci

How I can do the applymap?

HELP PLEASE

Re: Mapping - ApplyMap

martin59 — Fri, 11 Jan 2013 15:22:21 GMT

Hi,

You can't use the Mapping Functions in this case.

Mapping Table must have two fields.

If you want to join 2 tables with a date interval, you have to use IntervalMatch() Function.

I invite you to consult QV's help (F1) to have more informations on IntervalMatch().

Hope that helps you

Martin Favier

Re: Mapping - ApplyMap

farolito20 — Fri, 11 Jan 2013 15:41:34 GMT

I can't join :s

Do you know how to load from a qvd in vbscript?

Re: Mapping - ApplyMap

martin59 — Fri, 11 Jan 2013 15:45:18 GMT

You can only load a QVD with QlikView !

Martin Favier

Re: Mapping - ApplyMap

martin59 — Fri, 11 Jan 2013 15:51:08 GMT

But you can launch a QV task with a .bat file.

The .bat wich be used in your VBScript.

Martin Favier

Re: Mapping - ApplyMap

farolito20 — Fri, 11 Jan 2013 15:55:23 GMT

Any example? :s

Re: Mapping - ApplyMap

martin59 — Fri, 11 Jan 2013 15:59:26 GMT

The command line in the batch file would be :

"C:/Program Files/QlikView/Qv.exe" /r "C:/QlikView/MyApp.qvw"

You'll find more informations in QV help (F1).

Martin Favier

Re: Mapping - ApplyMap

ngulliver — Wed, 20 Feb 2013 11:34:19 GMT

Have a look at this blog. It may be of use to you. Steve has a number of useful blogs and videos on his site for beginners.

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Regards,

Neil.