Changing order of months

[ngulliver]

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

[#2 · Accepted solution]

Hi,

You can calculate the month field as:

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

Hope that helps.

-Khaled.

[Vegar]

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