topic Sort order in QlikView

Sort order

knightwriter — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Ive created a master calendar and from here I have created a list box of my data by week (ie 01/02/16-07/02/16 / W5) but the sort function wont allow me to go:

01/02/16-07/02/16 / W5

08/02/16-15/02/16 / W6

16/02/16-23/02/16 / W7

24/02/16-03/03/16 / W8 etc

any suggestions / expressions on how I can do this?

Thanks.

Re: Sort order

sunny_talwar — Wed, 08 Jun 2016 15:28:19 GMT

What is the expression you used to create this data by week field?

Re: Sort order

dmac1971 — Wed, 08 Jun 2016 15:29:27 GMT

Try and sort by load order? Your master calendar normally creates dates in sequential order so I use this to sort my dates into the right order.

Re: Sort order

knightwriter — Wed, 08 Jun 2016 15:33:48 GMT

Hi Sunny,

Sure, you've helped me enough times!

Date(WeekStart(TempDate),'DD/MM/YY') & '-' & date(WeekEnd(TempDate),'DD/MM/YY') & ' / w' & Week(TempDate) as [Created Date]

Re: Sort order

knightwriter — Wed, 08 Jun 2016 15:35:07 GMT

Thank you, I only had one option selected, so used Load Order and State -> Ascending