Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

[ASK] sort Week Of Year by Fiscal Week

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

8 Replies
Highlighted
Valued Contributor II

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

use sort expression as below

only({1}FYWeekOrder)

Highlighted
Not applicable

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

it change, but still uncorrect..

thx before

Highlighted
Not applicable

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

anyone?

Highlighted
Valued Contributor II

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

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

Highlighted
Not applicable

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

thx kumar..

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

let me know if there's any error in mine

many thx

Valued Contributor II

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

did you observed sheet3 , not sheet2 in my attachment ?

Highlighted
Not applicable

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

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.

Highlighted
Valued Contributor II

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

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 .