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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Month as numerical

Hi!

I need to have two month format in my app. 

Month name, e.g Jan, Feb etc in my graphs and numerical month in my filter.

I used these expressions and I want 'Month_cal' to be a numerical value between 1 and 12

Month(event_start_date)as Month

Month(event_start_date)as Month_cal

1 Solution

Accepted Solutions
Somasundaram
Creator III
Creator III

Use this,

Num(Month(event_start_date))as Month_cal


-Somasundaram

If this resolves your Query please like and accept this as an answer.

View solution in original post

1 Reply
Somasundaram
Creator III
Creator III

Use this,

Num(Month(event_start_date))as Month_cal


-Somasundaram

If this resolves your Query please like and accept this as an answer.