Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

laurent_ankri
New Contributor

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

Tags (2)
1 Solution

Accepted Solutions

Re: Month Format

=num(month(DATE_PRODUCT))

-Rob

http://robwunderlich.com

2 Replies

Re: Month Format

=num(month(DATE_PRODUCT))

-Rob

http://robwunderlich.com

laurent_ankri
New Contributor

Re: Month Format

Thanks a lot

Community Browser