topic Week Range Sorting in Cyclic Group in QlikView

Week Range Sorting in Cyclic Group

nehasaxena — Fri, 18 Nov 2016 07:36:56 GMT

Hello All,

I want to sort data in chart according to chronological week range. For Ex - 6/Jun 25/Jul 8/Aug.

I used calculated dimension for Week Range and Week Start Date - Date(WeekStart(TransactionDate),'MMM/DD')

Any help would be appreciated.

Regards,

Neha

Frank_Hartmann — Fri, 18 Nov 2016 11:00:03 GMT

have a look at the attached sample.

I used a mastercalendar to generate a field "WeekDiff" for Sorting!

notice: in chart --> sort --> expression = WeekDiff

hope this helps

enriquem — Fri, 18 Nov 2016 11:34:53 GMT

Hi,

Try to do a calendar dimension like this:

CALENDARIO:

Load

date

,week(date) as Week

Resident XXX

Order By date ASC;

And order the result by "Week" field.

Regards.

nehasaxena — Fri, 18 Nov 2016 13:00:00 GMT

Hey Frank,

Thanks

Best regards,

Neha