topic Re: Mapping in QlikView

Mapping

Mon, 15 Dec 2014 11:34:06 GMT

Plz any one Explaine me how to Use mapping function for perticular Type

Ex ; I have 3 Partner type

LES, RD, SRD

I need to apply Mapping differently for Each Partners

Re: Mapping

Mon, 15 Dec 2014 11:50:40 GMT

Explain your problem more in details, otherwise we can't help you.

Br,

Re: Mapping

Mon, 15 Dec 2014 12:31:29 GMT

Hi Tibor,

Assume, I have an Column Name Called [Partner Type] Having element's Called "LES,RD,SRD"

I have an Diff mapper for all those element's [LES, RD & SRD],

I need to Map this 3 Element differently in a Single Coloumn

Re: Mapping

Mon, 15 Dec 2014 12:33:07 GMT

If u Have any Materiel related QV Plz Send me to kushal@wyzmindz.com

Thank's and Regard's

Kushal.

Re: Mapping

Mon, 15 Dec 2014 12:35:29 GMT

What do you mean on mapping these values (in a single column)?

Re: Mapping

Anonymous — Mon, 15 Dec 2014 12:41:29 GMT

HI Kushal,

What is the result you are expecting.

Do you want to map in an object(UI) or in script to group the data?

please be specific.

Regards

Neetha

Re: Mapping

rajeshvaswani77 — Mon, 15 Dec 2014 12:53:11 GMT

Do you want to do like an excel lookup?

thanks,

Rajesh Vaswani

Re: Mapping

Mon, 15 Dec 2014 13:31:33 GMT

Yes

Re: Mapping

rajeshvaswani77 — Mon, 15 Dec 2014 13:34:25 GMT

Then you need to use an mapping load and then an applymap function. That's how you will do a lookup in QlikView.

Refer this thread

http://community.qlik.com/thread/98764

thanks,

Rajesh Vaswani

Re: Mapping

Mon, 15 Dec 2014 13:38:14 GMT

And a document about joins and lookups:

http://community.qlik.com/docs/DOC-3412

Best,

Re: Mapping

arsal_90 — Mon, 15 Dec 2014 13:43:03 GMT

Use Mapping Load

Mapping_Partner:

Mapping LOAD Partner Type,

PartnerID

FROM

Partner.qvd

(qvd);

Step 2: Apply this map to transaction table.

Transactions:

LOAD

CustomerID,

ProductID,

Amount,

ApplyMap ('Mapping_Partner', PartnerID,'Unknown')

FROM

Transactions.qvd

(qvd);