Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

[ASK] Sort by Fiscal Week

Hallo qlikview user..

i have an issue with sorting.

So in my chart i use WeekOfYear as dimension, and have an expression..

My sort is with expression (checked) : FiscalWeekOrder

But my sort result is still not as i expected.

How to solve this?

many thx

Tags (5)
6 Replies
Partner
Partner

Re: [ASK] Sort by Fiscal Week

Hi,

DId you try sorting using an expression?

Cheers,

Antoine

Not applicable

Re: [ASK] Sort by Fiscal Week

yes i did but still not as i expected..

Not applicable

Re: [ASK] Sort by Fiscal Week

can you attach your qvw?

MVP
MVP

Re: [ASK] Sort by Fiscal Week

This could be because - may be, your fiscal year field is created as text and there is no dual() used to give it a proper numerical value. Try to share your sample qvw here.

Partner
Partner

Re: [ASK] Sort by Fiscal Week

Please, post a screenshot of what is it doing now, and explain what is it that you expect.

Not applicable

Re: Re: [ASK] Sort by Fiscal Week

hello everyone..

many thx for your reply,

but i think it will more clear if we move to [ASK] sort Week Of Year by Fiscal Week

once again, many thx...