Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i search to sort a chart on Week + Day.
I have discribe my problem on the attached file.
Thanks for your help.
Sophie
Hi, use this calculated dimension (or create it in the script)
=dual([Semaine Jour enlèvement],[SemaineEnlèvement]*10 + [JourEnlèvement])
So, if the week is 26 and the day is 5, this will return 260 + 5 -> 265, then order by "numeric value"
rgds and good luck.
View solution in original post
uncheck your expression and select checkbox against text and numeric value.
it doesn't work too.
With this option the sort is wrong for the day.
Hi, Is this problem solved ?
If not, did you checked the box beside the "Text" "Z->A" under the sort tab just for the dimension Date with Month ?
The problem is not solved.
See on the attached file.
No, Just check the "Text" checkbox.
It's the same things ....
Hi,
If you want to achieve sorting chronological order while both selecting Week, or with no selection, just uncheck all sort options. By default, it would gives you the correct sort order no matter what the selection are made.
If you can, then post a sample data or sample qvw.
Of course, as attached.
