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: 
bhavvibudagam
Creator II
Creator II

How to get Month in Jan,Feb Format in Text Object

Hi Every one,

Can any one please help me on below issue.

I have one Date Field. From the Date Field I have derived the Month field from Date Field like below.

Load  Date,

          Month(Date) as Month

From

......

Then I have taken the Maximum Month as like below in Text Object

='Current Month' &'-'& Max(Month)

Got the Result as 12 instead of Dec. How to get the Month in the Dec format instead of 12.

Thanks,

1 Solution

Accepted Solutions
maxgro
MVP
MVP

another one

'Current Month' & ' - ' & Month(Date#(Max(Month), 'M')) 

View solution in original post

5 Replies
maxgro
MVP
MVP

maybe

='Current Month' &'-'&  Month(max(Date))

Frank_Hartmann
Master II
Master II

Load  Date,

          Date(Month(Date),'MMM') as Month

From...

maxgro
MVP
MVP

another one

'Current Month' & ' - ' & Month(Date#(Max(Month), 'M')) 

antoniotiman
Master III
Master III

='Current Month' &'-'& MaxString(Month)

its_anandrjs

And another way just add this line in your table

if(Month = Month(Today()),1,0) as Flag

Final:

LOAD *,

Month(Date) as Month,

if(Month = Month(Today()),1,0) as Flag

From Source;



And On front end in text object

='Current Month' &'-'& Only( {<Flag={1}>}Month)