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: 
Hemanth458
Contributor III
Contributor III

Cross table Month filed columns to month conversion

I had done cross table for Month columns into Month format by using Date(Date#(Left(Trim(Period),3),'MMM')) till here no issue for me but, When i have used Num() on top it then its given values as below:

MonthNum(Date(Date#(Left(Trim(Period),3),'MMM'))) O/pActual O/P
Jan-3631
Feb-3322
Mar-3043
Apr-2734
May-2435
Jun-2126
Jul-1827
Aug-1518
Sep-1209
Oct-9010
Nov-5911
Dec-2912

 

 

Labels (1)
1 Reply
sasiparupudi1
Master III
Master III

if your period is in the format JAN2019

 

Month(Date#('Jan2019','MMMYYYY'))

 

 hth