topic Re: Month Name in QlikView

Month Name

upaliwije — Wed, 06 Sep 2017 10:44:58 GMT

Dear Friends ,

I want to show the date in my report as shown below

Business Growth Report 1-Aug

There fore I in the header section I have written following expression But It shows the month number but it does not work . pls help me

='Business Growth Report ' & min(RISK_DAY)&'-'&monthname(max(RISK_MONTH))

kaushiknsolanki — Wed, 06 Sep 2017 10:53:35 GMT

What are the values of your Risk_Month field?

Regards,

Kaushik Solanki

upaliwije — Wed, 06 Sep 2017 10:55:08 GMT

marcus_sommer — Wed, 06 Sep 2017 10:57:11 GMT

You could try it in this way:

min(RISK_DAY)&'-'&date(max(RISK_DATE), 'MMM')

- Marcus

Kushal_Chawda — Wed, 06 Sep 2017 11:02:55 GMT

try this

='Business Growth Report ' & min(RISK_DAY)&'-'&month(MakeDate(year(Today()),max(RISK_MONTH),day(Today())))

its_anandrjs — Wed, 06 Sep 2017 11:07:42 GMT

Why not simply this you can try.

='Business Growth Report ' & min(RISK_DAY)&'-'&Month(max(RISK_MONTH))

='Business Growth Report ' & min(RISK_DAY)&'-'& Date( Month(max(RISK_MONTH)), 'MMM')

sunny_talwar — Wed, 06 Sep 2017 11:13:24 GMT

Another option

='Business Growth Report ' & min(RISK_DAY) &'-'& MaxString(RISK_MONTH)