topic Weeks asc wrong in QlikView

Weeks asc wrong

0li5a3a — Sun, 23 Jul 2017 19:09:51 GMT

Hi all.

Could you please hwlp me to sort the weeks problem?

I have something like this

The problem is... everything before 11 is 2017 data and all the rest are 2016 ... I used in the expression this calculation =count({$<Status= {'WP'}, CalendarPeriodnum={'>= $(=num(WeekStart(AddWeeks(max(CalendarPeriod),-15)))) <= $(=num(WeekEnd(max(CalendarPeriod))))'},YrWeek=,CalendarYear=>}TICKETID) and I think.

Any advices ?

I want the maximum week - 16

Re: Weeks asc wrong

arvind_patil — Mon, 24 Jul 2017 09:09:23 GMT

Hi Constantin,

Please provide sample data.

May be you need to sort in descending order.

Thanks,

Arvind Patil

Re: Weeks asc wrong

0li5a3a — Wed, 26 Jul 2017 15:20:30 GMT

Hi Arvind,

I fixed my problem. Thanks your your message.

Regards,