topic Re: Sorting Weekday Dynamically in QlikView

Sorting Weekday Dynamically

narband2778 — Sat, 16 Nov 2024 02:20:00 GMT

Hello Everyone,

Want to sort Weekday in a given chart should be driven by Today() function:

For example:

If Today() is Wednesday the Chart "Week Day" Dimension should start with 'Thu', 'Fri', and so on.

If Today() is Thursday the chart "Week Day" Dimension should start with 'Fri', 'Sat', and so on.

Thanks in advance.

Frank_Hartmann — Wed, 02 Oct 2019 10:42:41 GMT

try like this:

Load *, Mod(Nr -(Day(Today(1))+2),7)+1 as Test; TEST: LOAD * Inline [ Day, Nr Mon, 1 Tue, 2 Wed, 3 Thu, 4 Fri, 5 Sat, 6 Sun, 7 ];

and then use "Test" for sorting.

hope this helps

narband2778 — Wed, 02 Oct 2019 12:29:59 GMT

Thanks Frank. Worked pretty well.