Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use sort expression as below
only({1}FYWeekOrder)
it change, but still uncorrect..
thx before
anyone?
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
thx kumar..
i also have updated my file to fulfill my requirement..
let me know if there's any error in mine
many thx
did you observed sheet3 , not sheet2 in my attachment ?
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 .