Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Giovane
Creator
Creator

Issue Related to Month Date Format

Who can help me?

When I do Month(Date) - And Date has the format DD/MM/YYYY - I got, for example, dez as the result. How do I do to get 12, instead of dez, as the result? 

Thanks a lot !!!

 

 

 

 

1 Solution

Accepted Solutions
MindaugasBacius
Partner
Partner

I would like to improve Mwoolf solution a liitle:
Num(Month(Date), '00')

Now you will get 01, 02, 03 ... 12. In times when you will for example concatenate Year and Month as 2019-01, 2019-02, 2019-03 ... 2019-12 that will provide consistent visualization.
Without formatting you will get 1, 2, 3 ... 12 and Year month field will look like this 2019-1, 2019-2, 2019-3 ... 2019-12.

View solution in original post

4 Replies
m_woolf
Master II
Master II

Try:

num(Month(Date))

nilaksh92
Partner
Partner

Please try to implement like this.

 

=Num(Month(Date(now(),'DD/MM/YYYY')))

MindaugasBacius
Partner
Partner

I would like to improve Mwoolf solution a liitle:
Num(Month(Date), '00')

Now you will get 01, 02, 03 ... 12. In times when you will for example concatenate Year and Month as 2019-01, 2019-02, 2019-03 ... 2019-12 that will provide consistent visualization.
Without formatting you will get 1, 2, 3 ... 12 and Year month field will look like this 2019-1, 2019-2, 2019-3 ... 2019-12.

View solution in original post

Giovane
Creator
Creator
Author

Best answer...your tip fixed completely my issue.

Thanks for all the contributions.