Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
DId you try sorting using an expression?
Cheers,
Antoine
yes i did but still not as i expected..
can you attach your qvw?
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.
Please, post a screenshot of what is it doing now, and explain what is it that you expect.
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...