topic mapping in QlikView

mapping

satheshreddy — Mon, 26 Jan 2026 16:26:21 GMT

ma:

mapping load * inline

[Month,Quarter

Jan,Q1

Feb,Q1

Mar,Q1

Apr,Q2

May,Q2

Jun,Q2

Jul,Q3

Aug,Q3

Sep,Q3

Oct,Q4

Nov,Q4

Dec,Q4

];

LOAD [Transaction ID],

Year,

Month,

Day,

[Salesman ID],

[Product ID],

[Serial No],

[ID Customer],

[List Price],

Sales,

[Gross Margin],

MakeDate(Year,Month,Day) as tdate,

ApplyMap('ma',Month)

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

apply map result gives

but my intention is applymap output LIKE THIS

ANY ONE HELP ME

REGARDS

S REDDY

Re: mapping

prabhas277 — Sat, 18 Apr 2015 07:34:10 GMT

Hi,

The output is not possible because only unique values are stored in qlikview.

so the output like this only

Try this code:

Ma:

MAPPING

load * inline

[

month,quarter

jan,Q1

feb,Q1

mar,Q1

.. ....

dec,Q4

];

QUARTER:

LOAD

Year,

month,

applymap ('Ma',month) as new,

Day

FROM

PLESE FIND THE below file.if it is useful tick the correct answer.

Re: mapping

maxgro — Sat, 18 Apr 2015 07:40:03 GMT

applymap gives

because your Month is a number in Transact table and a month name in ma table

and when applymap doesn't find a match it returns the 2nd parameter (month number)

try to change the maping table (ma) usng number, 1 not Jan, 2, ot Feb, etc......

Re: mapping

Sat, 18 Apr 2015 09:16:07 GMT

Hi,

I agree with Massimo but instead of the apply map you could also do something like:

'Q' & Ceil(Month/3) AS Quarter

Could be simpler in your case.

Kind regards,

Nuno

Re: mapping

satheshreddy — Sat, 18 Apr 2015 13:29:28 GMT

hi prabhas,

these type also comes

same out put.

thanks

s.reddy