Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Applymap don't work!!

Hi every one

I have made a mapping tabel:

Map:

Mapping  LOAD Bron1,

     Bron2

FROM

(biff, embedded labels, table is Sheet1$);

and the follow table with the applymap;

Tabel:

LOAD date(Date#( date ,'YYYYMMDD'),'DD-MM-YYYY') as date,

    sourceMedium as verkeersbron,

    sessions as sessies,

    applymap('Map',bron1) as Bron2

FROM [http://research.ilsemedia.nl/query-tool/app/viewcustomreport.php?report=477&format=xml] (XmlSimple, Table is [data/query0/row]);

But it dont work someone suggestions?

@

10 Replies

Re: Applymap don't work!!

I think you need to replace bron1 with the field in your current Tabel (either sourceMedium or sessions).

Tabel:

LOAD date(Date#( date ,'YYYYMMDD'),'DD-MM-YYYY') as date,

    sourceMedium as verkeersbron,

    sessions as sessies,

    applymap('Map',bron1) as Bron2

FROM [http://research.ilsemedia.nl/query-tool/app/viewcustomreport.php?report=477&format=xml] (XmlSimple, Table is [data/query0/row]);


Look QlikView's help for an example: QlikView ‒ ApplyMap - script function

Not applicable

Re: Applymap don't work!!

Hi sunny

how do you mean

MindaugasBacius
Valued Contributor II

Re: Applymap don't work!!

Applymap(<map that you have created>, <the field name that is in the table where you what to use Applymap function>)

Re: Applymap don't work!!

I am assuming you don't have bron1 in your data coming from the XML file, right? You need to use a field which is equivalent of bron1 in your XML file. We don't use the field name from Mapping Table load here.

Not applicable

Re: Applymap don't work!!

But  i have tried also source medium but it dont works

Not applicable

Re: Applymap don't work!!

Tabel:

LOAD date(Date#( date ,'YYYYMMDD'),'DD-MM-YYYY') as date,

    sourceMedium as verkeersbron,

    sessions as sessies,

    applymap('Map',verkeersbron) as Bron2

FROM [http://research.ilsemedia.nl/query-tool/app/viewcustomreport.php?report=477&format=xml] (XmlSimple, Table is [data/query0/row]);

Re: Applymap don't work!!

Try this:

Tabel:

LOAD date(Date#( date ,'YYYYMMDD'),'DD-MM-YYYY') as date,

    sourceMedium as verkeersbron,

    sessions as sessies,

    applymap('Map',sourceMedium) as Bron2

FROM [http://research.ilsemedia.nl/query-tool/app/viewcustomreport.php?report=477&format=xml] (XmlSimple, Table is [data/query0/row]);

Not applicable

Re: Applymap don't work!!

Ok, i gonna trie it

I wanna match sourcemedium with bron 2

Not applicable

Re: Applymap don't work!!

Sunny

Great !!

It works thanks for your hulp!!