topic Re: [ASK] sort Week Of Year by Fiscal Week in QlikView

[ASK] sort Week Of Year by Fiscal Week

Thu, 22 May 2014 06:46:55 GMT

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

Re: [ASK] sort Week Of Year by Fiscal Week

preminqlik — Thu, 22 May 2014 06:59:54 GMT

use sort expression as below

only({1}FYWeekOrder)

Re: [ASK] sort Week Of Year by Fiscal Week

Thu, 22 May 2014 07:11:52 GMT

it change, but still uncorrect..

thx before

Re: [ASK] sort Week Of Year by Fiscal Week

Thu, 22 May 2014 08:29:47 GMT

anyone?

Re: Re: [ASK] sort Week Of Year by Fiscal Week

preminqlik — Thu, 22 May 2014 09:24:21 GMT

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

Re: Re: Re: [ASK] sort Week Of Year by Fiscal Week

Thu, 22 May 2014 09:30:31 GMT

thx kumar..

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

let me know if there's any error in mine

many thx

Re: [ASK] sort Week Of Year by Fiscal Week

preminqlik — Thu, 22 May 2014 09:46:53 GMT

did you observed sheet3 , not sheet2 in my attachment ?

Re: [ASK] sort Week Of Year by Fiscal Week

Thu, 22 May 2014 12:53:26 GMT

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.

Re: [ASK] sort Week Of Year by Fiscal Week

preminqlik — Thu, 22 May 2014 13:55:41 GMT

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 .