topic Month to month number in QlikView

Month to month number

Mon, 10 May 2010 13:36:44 GMT

Hi,

can anybody suggest how to get month number from month like 'Apr' to 04, Is there any specific function available in qlik view

Thanks & Regards,

Arun

Month to month number

Mon, 10 May 2010 13:45:26 GMT

Hi Arun

Enter "date" in the search field of the help. You will see an entry "Date and time functions".

=month(now()) will give you the month name

=num(month(now())) will give you the month number

QlikView has in most cases a numeric and string representation for values (I strongly suggest to read through part II of book 2 in the documentation, "Data Types in QlikView")

Regards

Jürg

Month to month number

Mon, 10 May 2010 13:54:42 GMT

Hi Arun,

you can sole your question by usung this code....

num(month(field name)). Hope this helps

Thanks joseph.....

Month to month number

Tue, 13 Sep 2011 18:36:02 GMT

In addition to juergm' and joseph.thoppil' answers: you can add format-code to obtain your month in two figures [01, 02, 03 ... 12].

num(Month(field name), '00')

Bye

Marco.

Month to month number

Anonymous — Wed, 14 Sep 2011 05:19:25 GMT

Hi,

Check this link,

http://community.qlik.com/thread/34277

Month to month number

rohit214 — Wed, 14 Sep 2011 06:02:16 GMT

hey arun

use

num(month(now()))

thanks

rohit

Month to month number

Wed, 14 Sep 2011 06:44:19 GMT

Hey Arun

try this

(monthnum(date_field))

thanks

Rathish