topic Re: Map / Aggretation of Values in QlikView

Map / Aggretation of Values

fs24 — Tue, 31 Jan 2023 14:51:44 GMT

Hi there,

I have an issue to solve this problem.

I have a table with transactions and a column utm_source_source containing source of transaction (for example www.google.de, www.google.com, bing.com, cpc,... etc )).

now i want to aggreate some values to utm_source categories (for example www.google.de and www.google.com should show up as 'organic', and the rest as their initial value from utm_source_first

for test i made a source map in the script

Source_Map:
Mapping Load * inline
[utm_source_first, Aggregation
'www.google.de','organic'
'www.google.com','organic'
'belboon','affiliate'
];

but how i can use this source map in the expression calculation for my dimension ? i tried with a

=ApplyMap('Source_Map',utm_source_first,'other')

but this just result into error 🙂

Re: Map / Aggretation of Values

marcus_sommer — Tue, 31 Jan 2023 15:11:50 GMT

Mapping + applymap() are script-features and couldn't be used within the UI. Just load the table without the mapping prefix and you could use both fields as dimension and adding any expression like count(whatever).

Re: Map / Aggretation of Values

fs24 — Tue, 31 Jan 2023 21:05:02 GMT

thx for the hint. thats indeed an much easier solution 🙂