Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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')) 

View solution in original post

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)