2 Replies Latest reply: May 10, 2012 5:39 AM by VARUN BHANDARY RSS

    Change qlikviews definition of month numbers to financial

    Matthew Green

      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?

        • Re: Change qlikviews definition of month numbers to financial
          Teemu Pitkänen

          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

          • Change qlikviews definition of month numbers to financial
            VARUN BHANDARY

            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