[ASK] Sort by Fiscal Week

[#1]

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

[Anonymous]

Hi,

DId you try sorting using an expression?

Cheers,

Antoine

[#3]

yes i did but still not as i expected..

[#4]

can you attach your qvw?

[tresesco]

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.

[Anonymous]

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

[#7]

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...