Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

bharatsrini123
New Contributor

Conversion of data question

Hi all,

I am creating a dashboard from a Mysql table. One of the columns in the table is days which provides data ranging from 1-7 in the format 1,2,3 or 1,2,3,4 which corresponds to Sun,Mon,Tues and Sun,Mon,Tues,Wed respectively. Please let me know an efficient way to map the numbers to the days. Thanks.

1 Reply
Digvijay_Singh
Honored Contributor III

Re: Conversion of data question

Different ways are available to achieve this -

You may have mapping table -

Days_Map:

Mapping load

* inline [

DayNum, Days

1,Sun

2,Mon

3,Tue

4,Wed

5,Thu

6,Fri

7,Sat

];

Use Dual(Applymap('Days_Map',actualfieldname),Actualfieldname) as Newfieldname

Dual will help to use the same field in calculation as well, in visualization it will show the days in text.

If you have date field available and you have possibility to create days field from that then you can use date functions Day(Date) function to have the same dual field directly.

Community Browser