topic Month Year not getting correct in the chart in QlikView

Month Year not getting correct in the chart

kamalqlik — Wed, 14 Dec 2011 13:01:34 GMT

Hi friends

I am using a Line chart ....which have the dimension as calculated dimension in form of

If((year([Estimated Close Date])>2009),Month([Estimated Close Date]) & '-' & Right(year([Estimated Close Date]),2)).

when I am using the chart I get the Month year in format.

Apr-10

Apr-11

Aug-10

Aug-11..

but I want the output as

Apr-10

Aug-10

Apr-11

Aug-11.

Please give me some suggestion of how to do that.

regards

Kamal

Wed, 14 Dec 2011 14:02:07 GMT

Hi Kamal,

Try the sorting numerical -> ascending for this dimension in the Tab Sorting.

Regards

vicky

jagan — Thu, 15 Dec 2011 08:38:32 GMT

Hi,

Try this expression

If((year([Estimated Close Date])>2009),

Date([Estimated Close Date], 'MMM-YY'))

Then select Ascending/Descending as required.

Regards,

jagan.

Thu, 15 Dec 2011 19:32:44 GMT

Or try:

If((year([Estimated Close Date])>2009),Monthname([Estimated Close Date])).