topic Re: Need help in expression in QlikView

Need help in expression

Thu, 12 Jul 2012 08:48:20 GMT

Hello Friends,

I have column name as Invoice Date it contains value of YYYY-MM-DD like (2011-01-23), my requirement is I need to create dimention like Jan 2011.

I tried YearMonth(Invoice_Date) in script level and in expression level.

I am not getting any solution for that, could you please any one suggest a way to show Monthname and Year.

Regards

Chriss

nagaiank — Thu, 12 Jul 2012 08:53:03 GMT

Try

MonthName(Invoice_Date)

For 2011-01-23, this will return 'Jan 2011'

Thu, 12 Jul 2012 08:54:57 GMT

Hello chrismervin,

have you tried to use the date function?

like date(Invoice_Date,'MM YYYY') ?

Regards,

Aylin

Thu, 12 Jul 2012 08:57:58 GMT

Hello Sir,

Thanks a lot it works

Regards

Chriss