topic Sort (week + day) on chart in QlikView

Sort (week + day) on chart

Anonymous — Mon, 12 Jul 2010 12:58:33 GMT

Hello,

i search to sort a chart on Week + Day.

I have discribe my problem on the attached file.

Thanks for your help.

Sophie

Sort (week + day) on chart

Mon, 12 Jul 2010 13:07:34 GMT

uncheck your expression and select checkbox against text and numeric value.

Sort (week + day) on chart

Anonymous — Mon, 12 Jul 2010 13:34:18 GMT

it doesn't work too.

With this option the sort is wrong for the day.

Sort (week + day) on chart

Mon, 12 Jul 2010 13:48:34 GMT

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 ?

Sort (week + day) on chart

Anonymous — Mon, 12 Jul 2010 14:00:14 GMT

The problem is not solved.

See on the attached file.

Sort (week + day) on chart

Mon, 12 Jul 2010 14:02:01 GMT

No, Just check the "Text" checkbox.

Sort (week + day) on chart

Anonymous — Mon, 12 Jul 2010 14:09:11 GMT

It's the same things ....

Sort (week + day) on chart

niceqlik — Mon, 12 Jul 2010 14:45:35 GMT

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.

Sort (week + day) on chart

Mon, 12 Jul 2010 14:48:55 GMT

Hi,

If you can, then post a sample data or sample qvw.

Sort (week + day) on chart

niceqlik — Mon, 12 Jul 2010 15:49:35 GMT

Of course, as attached.

Sort (week + day) on chart

Anonymous — Mon, 12 Jul 2010 16:17:45 GMT

It's not good for me.

Look in my exemple s.27 mer. must be before s.27 jeu.

Sophie

Sort (week + day) on chart

hector — Mon, 12 Jul 2010 17:17:36 GMT

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.

Sort (week + day) on chart

Anonymous — Tue, 13 Jul 2010 09:20:13 GMT

Good for me

Thanks

Sophie