topic Re: Chart - sorting by Financial Year in QlikView

Chart - sorting by Financial Year

Thu, 09 May 2013 11:04:44 GMT

Hi,

I have a requirement whereby I need to sort a Line Chart by Months - with the first month being April (April to Mar)

Is there a way I can do this?

Many Thanks

sujeetsingh — Thu, 09 May 2013 11:08:52 GMT

If it is months then short it like TEXT

sujeetsingh — Thu, 09 May 2013 11:16:37 GMT

And if you are having a big data then just write up an expression .

Thu, 09 May 2013 11:19:02 GMT

Could you provide me with an example please?

Will I use the TEXT function in the Expression option in the Sort tab?

Many thanks for your help

sujeetsingh — Thu, 09 May 2013 11:23:46 GMT

Its ok i am to just exploring......

Thu, 09 May 2013 11:30:21 GMT

hi,

Type1:use in sort expression

match(Month, 'April','may','jun','jul','Aug','Sep','Oct','Nov','Decr','Jan','Feb','Mar')

Type2:

(Num(Month([M Date]))>=4 AND Num(Month([M Date]))<=12,(Num(Month([M Date]))-3),(Num(Month([M Date]))+9)) AS MonthNumber

after using this statement in script

use sort by expression: = month number.

Hope it will Help

sujeetsingh — Thu, 09 May 2013 11:30:29 GMT

Brian.

In script editor there is order of month declaration as

SET MonthName=Jan,Feb........

Change it accordingly......as you need

Then sort it accordingly.