Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Mapping function

i am trying to write a code in mapping function..but i have face some errors.. i am create 2 tables one table name is

Trans table.and another table is tab table.In that tab table i am creating mapping load inline table.my code problem is month..when i am execute the program  month field is comes in *****..but i want to display in month jan,feb like that ..please help me..i am upload my qvw file....

It shows like that

Year1     Month1  Month

2004     ****          1

2004     ****          3

but i am looking like that

Year1     Month1  Month

2004          jan     1

2004         march   3

1 Solution

Accepted Solutions
greeshma_k
Contributor III

Re: Mapping function

Hi,

In your mapping table, the field names are comma separated and actual values are separated by space. Change the mapping table as below

Mapping LOAD * Inline

[
month, desc
1,jan
2,feb
3,march
4,apr
5,may
6,jun
7,jul
8,aug
9,sep
10,oct
11,nov
12,dec
]
;

Regards,

Greeshma

View solution in original post

2 Replies
greeshma_k
Contributor III

Re: Mapping function

Hi,

In your mapping table, the field names are comma separated and actual values are separated by space. Change the mapping table as below

Mapping LOAD * Inline

[
month, desc
1,jan
2,feb
3,march
4,apr
5,may
6,jun
7,jul
8,aug
9,sep
10,oct
11,nov
12,dec
]
;

Regards,

Greeshma

View solution in original post

Not applicable

Re: Mapping function

thank you very much greeshma.k its working