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.
hi rendi , i have done some changes to full fill your requirement , with the reference of @hic posts
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.
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 .