Change qlikviews definition of month numbers to financial

[#1]

Hi all,

By default, qlikview recognises December as month 12, is it possible to change this to a financial system?

We go from July to June.

The issue I face is when trying to figure out the max(month) selected, if I highlight Nov-Feb, then qlikview decides that December is the max, not February. 

i could probably figure this out using some crazy expression, but I was hoping there was an easier way..

Thoughts?

[teempi]

Hi Matt,

You could create an inline table that has new values for each calendar month. For example

FinancialPeriod:

LOAD * INLINE [

     CalendarMonth, FinancialPeriod

     Jul, 1

     Aug, 2

     Sep, 3

     Oct, 4

     Nov, 5

     Dec, 6

     Jan, 7

     Feb, 8

     Mar, 9

     Apr, 10

     May, 11

     Jun, 12

];

If you have a calendar table already, you can just join the inline table with it. You can then select months from your regular month and max(financialPeriod) will give you the result you want.

-Teemu

[varunpbhandary]

Hi Matt,

You may also calculate the order of months like this.

Put the order according to your preference

wildmatch(month(Date),'Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May') as MonthOrder

Cheers!

Varun Bhandary