Monthname function bug

[gchampion]

Hi,

I noticed a bug when using "Monthname" function in the dimension of a chart.

This bug appears when only one month is selected.

Am I the only one to notice it and be upset by this bug ?

Is this bug referenced ?

Do we have another simple workaround in a calculated dimension ? may be by using Date(Date,'MMM-YYYY') ?

Please see my sample app to reproduce the problem (temp2.qvw).

Best regards,

Guillaume

[#2]

It might be related to the version of QlikView you are using.

I opened your QVW on my 10 SR3 and the results were as expected (Both the charts were showing 'fevr 2012')

[gchampion]

My version is QV11 SR1.

[rwunderlich]

That's an interesting problem. I recommend you contact support.

-Rob

[erichshiino]

It looks like a bug...

I'm using 11 SR1 and got the same wrong result.

Maybe you already found a workaround, but if not, you can use this:

=date(F1,'MMM')

Regards,

Erich

[brenner_martina]

Hi,

that's really funny, it takes always the monthname of the first line in your inline table! Maybe it is not by loading tables from other sources!

Greetings from Munich

Martina

[sivarajs]

Setting monthname in script might helps i guess

[gchampion]

Unfortunatly date formatting function used in dimension doesn't aggregate properly data.

See my new test.

[gchampion]

I don't see any change with my first app !?

[whiteline · Accepted solution]

Hi, gchampion.

=date(F1,'MMM') doesn't discard days (only changes text format).

Try this instead:

=date(makedate(year(F1), month(F1)), 'MMM')