Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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