topic Re: Sort Order Week - Weekday in QlikView

Sort Order Week - Weekday

Fri, 15 Jan 2016 23:00:57 GMT

Hi i am having difficulty sorting the following field Week-Weekday.

i have tried Match(weekday,'MÅ,'TI','ON','TO','FR','LÖ','SÖ') without sucess.

does anyone have a solution to this?

Best

Brad

Re: Sort Order Week - Weekday

swuehl — Fri, 15 Jan 2016 23:06:43 GMT

Maybe sort by expression

=YourDateField

Re: Sort Order Week - Weekday

Fri, 15 Jan 2016 23:16:30 GMT

Hi!

still no luck here potential problem is that sorting is on a pivot table dimension with CY and LY values. is it possible to point at the max year and then sort from monday-sunday?

/Brad

Re: Sort Order Week - Weekday

sunny_talwar — Sat, 16 Jan 2016 02:42:02 GMT

Would you be able to share a sample?

Re: Sort Order Week - Weekday

stabben23 — Sun, 17 Jan 2016 19:25:00 GMT

Hi, You have a cyclic Group, try to sort inside this group instead.

Re: Sort Order Week - Weekday

MarcoWedel — Mon, 18 Jan 2016 01:03:09 GMT

Hi,

maybe one solution could be:

table1:
LOAD *,
    Dual(Week(Datum)&' '&WeekDay(Datum),Datum) as [Vecka Veckodag],
    Week(Datum) as Vecka,
    WeekDay(Datum) as Veckodag,
    Month(Datum) as Månad,
    Year(Datum) as År;
LOAD Date(MakeDate(2015)+RecNo()-1) as Datum,
    Ceil(Rand()*100) as SomeFact
AutoGenerate 365;

hope this helps

regards

Marco