topic Re: Sort chart on Day Hour in QlikView

Sort chart on Day Hour

mp802377 — Mon, 26 Dec 2016 16:39:27 GMT

I have a chart. First dimension is =Weekday(Date)&' '&num(hour,'00')&':00' second dimension is =Date(WeekStart(Date, 0, -1), 'DD-MMM-YY') . Then of course the expression. I like the chart overall, but I have sort issues. The data starts for the Sunday prior, but the sort on the axes is not starting on Sunday, but on Friday. I have tried changing to expression and sorting on date, but that is not working. Here is what I created:

Below is the chart I was told to create from. The 1 is Sunday, the 2 is Monday, the three is Tuesday and so on. I am sure they will be fine how I have it (to me having the actual day instead of a number is better), but they will want the sort to start on Sunday and not Friday. How do I fix that? Thank you for your help.

Re: Sort chart on Day Hour

swuehl — Mon, 26 Dec 2016 18:51:30 GMT

As first dimension, try a dual value:

=Dual( Weekday(Date)&' '&num(hour,'00')&':00' , Date + hour/24 )

Then sort numeric.

Re: Sort chart on Day Hour

mp802377 — Mon, 26 Dec 2016 18:58:12 GMT

When I try that the weeks are no longer comparing each other but adding on to the end. So it makes just one line.

Re: Sort chart on Day Hour

swuehl — Mon, 26 Dec 2016 19:29:45 GMT

Ok, then try (with a recent version of QV):

=Dual( Weekday(Date)&' '&num(hour,'00')&':00' , Weekday(Date,6) + hour/24 )

Re: Sort chart on Day Hour

mp802377 — Tue, 27 Dec 2016 00:13:30 GMT

thank you so much! that worked! I had tried the other previously and had the one line, but the =Dual( Weekday(Date)&' '&num(hour,'00')&':00' , Weekday(Date,6) + hour/24 ) worked. Thank you again!