topic Convert numeric data type value to Text datatype in QlikView

Convert numeric data type value to Text datatype

Fri, 23 Apr 2010 10:08:51 GMT

Hi All,

Please help me on this, I Have a column containing Month value in Format Jan, feb, Mar, .....etc i want current and previous month togather but by doing - "Jan -1" instead of "Dec" i am getting 12. How can I convert this "12" in to Dec.

Hope I m clear at my point....

Please help me on this....Thanks

Rahul

Convert numeric data type value to Text datatype

sparur — Fri, 23 Apr 2010 10:30:47 GMT

Hi, Rahul.

You can to use a map table:

monthnum, mothname

1, Jan

2, Feb

...

12, Decand use this table to convert your expression (12 into Dec). see more details about mapping in help, search by words: mapping, applymap

Convert numeric data type value to Text datatype

spsrk_84 — Fri, 23 Apr 2010 10:49:57 GMT

Hi,

Write a calculated Dimension if u wnat to see the output in charts else use a if condition in script like if( MnthValue=1,'Jan',if( MnthValue=2,'feb'

Like above repeat the if statements till u reach 12 th month.

Regards,

Ajay

Convert numeric data type value to Text datatype

spsrk_84 — Fri, 23 Apr 2010 10:51:29 GMT

eveb Mapping Table is very usefull in this regard.