[ASK] sort Week Of Year by Fiscal Week

[#1]

Hallo QlikView..

I have an issue for sort by fiscal week order.

I have a barchart that show summary of values by Calendar Week (1-52).

And I need to sort it by Fiscal Week Order.

Where Fiscal Month start on April Current Year until March Next Year.

I've created Fiscal Week Order, but it still have an issue that the sort is uncorrect.

Because one Week of Year can split in two Fiscal Week Order or one Fiscal Week Order can split in two Week of Year.

How to solve this?

Also, i've attached sample files.

Many thx

[preminqlik]

use sort expression as below

only({1}FYWeekOrder)

[#3]

it change, but still uncorrect..

thx before

[#4]

anyone?

[preminqlik]

hi rendi , i have done some changes to full fill your requirement , with the reference of @hic posts

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

find attachment

!

see sheet2

@premhas

[#6]

thx kumar..

i also have updated my file to fulfill my requirement..

let me know if there's any error in mine

many thx

[preminqlik]

did you observed sheet3 , not sheet2 in my attachment ?

[#8]

yes i did check sheet 3..

but when i change dimension to week, result isn't as expected..

maybe you can compare to my version to..

so we can update it if you find any mistake in my version.

[preminqlik]

mistake is ,

default qlikview treat the week starting with periodically 7 days per one week.,so for example for max year in your case i.e 2014 while running financial year with normal calendar you get week no 13 as starting. because it is treating april day 1 as week no 13, wrt to normal year which is incorrect.

and while running financial year you'l get the exact result , since from april 1st  it will treat week as 1 .