Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Month Format

Hi

I want to use the month function in a graph

I have the column DATE_PRODUCT with the format yyyy/mm/dd

I want to show the month in numeric format

But when I write month(DATE_PRODUCT), the result is the name of the month and not the number of the month

What can I do ?

Thanks for your help

Lauren

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
MVP
MVP

2 Replies
rwunderlich
MVP
MVP

=num(month(DATE_PRODUCT))

-Rob

http://robwunderlich.com

Anonymous
Not applicable
Author

Thanks a lot