Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kamalqlik
Valued Contributor

Month Year not getting correct in the chart

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

3 Replies
Not applicable

Month Year not getting correct in the chart

Hi Kamal,

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

Regards

vicky

MVP & Luminary
MVP & Luminary

Month Year not getting correct in the chart

Hi,

Try this expression

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

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

Then select Ascending/Descending as required.

Regards,

jagan.

Not applicable

Month Year not getting correct in the chart

Or try:

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