Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert number into Month

Hi,

I have a scenario like below,

Test=201216

I have to convert this value into month by below case,

201216 as DEC 16, last two digits are number(16), and 3rd and 4th digits represents as month(ex: 12 as DEC,1 as JAN,2 as FEB,etc..)

Thanks,

Mahi

5 Replies
sunny_talwar

May be like this:

Month(Date('201216', 'DDMMYY'))

sunny_talwar

My bad, try this:

=Month(Date#('201216', 'DDMMYY'))

Not applicable

Sunny,

I have to use column name 'Test' to convert the set of values, for example

if 201216 -->DEC 16

200810-->AUG 10

Thanks,

Mahesh

sunny_talwar

Try this:

=Date(Date#(Test, 'DDMMYY'), 'MMM YY') as Test

MarcoWedel

maybe

=Date(MonthStart(Date#(Test, 'DDMMYY')), 'MMM YY') as Test


to avoid multiple values with the same text representation but different numerical values.


regards

Marco