topic Re: How to get Month in Jan,Feb Format in Text Object in QlikView

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

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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,

maxgro — Sat, 30 Sep 2017 14:39:52 GMT

maybe

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

Frank_Hartmann — Sat, 30 Sep 2017 14:44:42 GMT

Load Date,

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

From...

maxgro — Sat, 30 Sep 2017 14:56:53 GMT

another one

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

antoniotiman — Sat, 30 Sep 2017 15:44:05 GMT

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

its_anandrjs — Sat, 30 Sep 2017 17:27:49 GMT

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)