topic Re: Monthname function bug in QlikView

Monthname function bug

gchampion — Thu, 06 Sep 2012 21:48:12 GMT

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

Re: Monthname function bug

Thu, 06 Sep 2012 22:25:38 GMT

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')

Re: Monthname function bug

gchampion — Thu, 06 Sep 2012 22:27:26 GMT

My version is QV11 SR1.

Re: Monthname function bug

rwunderlich — Thu, 06 Sep 2012 22:30:44 GMT

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

-Rob

Re: Monthname function bug

erichshiino — Fri, 07 Sep 2012 03:16:55 GMT

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

Re: Monthname function bug

brenner_martina — Fri, 07 Sep 2012 10:14:59 GMT

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

Re: Monthname function bug

sivarajs — Fri, 07 Sep 2012 11:50:11 GMT

Setting monthname in script might helps i guess

Re: Monthname function bug

gchampion — Sun, 09 Sep 2012 01:15:30 GMT

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

See my new test.

Re: Monthname function bug

gchampion — Sun, 09 Sep 2012 01:16:12 GMT

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

Re: Monthname function bug

whiteline — Sun, 09 Sep 2012 18:09:18 GMT

Hi, gchampion.

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

Try this instead:

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

Re: Monthname function bug

gchampion — Sun, 09 Sep 2012 21:45:09 GMT

Thank's this workaround works perfectly.

Now QlikTech has to correct monthname function behavior in QV11 🙂

Thank's