Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ngulliver
Not applicable

Changing order of months

I have a table in which I would like to show months running from July to June instead of January to December.

I have tried

if(Month < 7, Month + 6, Month - 5)

but this seems to convert the months to numbers (e.g. January = 1) and I wish to retain the month as a word.

Is there another way ?

What makes this more complex is that the month field is part of a cycle group.

Thanks,

Neil

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Changing order of months

Hi,

You can calculate the month field as:

dual(month(DateField),mod(month(DateField)+7,12)) as Month,

Hope that helps.

-Khaled.

2 Replies
Not applicable

Re: Changing order of months

Hi,

You can calculate the month field as:

dual(month(DateField),mod(month(DateField)+7,12)) as Month,

Hope that helps.

-Khaled.

Vegar
Not applicable

Re: Changing order of months

You could introduce a fiscal month number in your master calendar OR

just sort your month dimension by a fiscal month expression.

In any case you can use the expression below. 6 = Fiscal year starts in July

num(month(MonthStart(Date,(6))))

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se

Please ekskuse my Norglish and Swenglish typos.