Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can calculate the month field as:
dual(month(DateField),mod(month(DateField)+7,12)) as Month,
Hope that helps.
-Khaled.
Hi,
You can calculate the month field as:
dual(month(DateField),mod(month(DateField)+7,12)) as Month,
Hope that helps.
-Khaled.
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
QlikView consultant at egbs consulting ab
Blog (in Swedish): bi-effekten.se