Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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
Author

Hi sunny

how do you mean

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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

sunny_talwar

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
Author

But  i have tried also source medium but it dont works

Not applicable
Author

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]);

sunny_talwar

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
Author

Ok, i gonna trie it

I wanna match sourcemedium with bron 2

Not applicable
Author

Sunny

Great !!

It works thanks for your hulp!!