
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Month to month number
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Arun,
you can sole your question by usung this code....
num(month(field name)). Hope this helps
Thanks joseph.....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hey arun
use
num(month(now()))
thanks
rohit

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey Arun
try this
(monthnum(date_field))
thanks
Rathish
