topic Re: Sorting Problem in Week List box in QlikView

Sorting Problem in Week List box

tulasiram_bitra — Sat, 19 Dec 2015 09:52:19 GMT

Hi Frnz,

I would like to show Week 1 to Week 53. But it showing Wk53 first after this Normal Week 1 to Week 52.

How to show from week 1 to week 53?

Please let me know. Please find the attached image.

swuehl — Sat, 19 Dec 2015 13:03:50 GMT

Have you tried to sort the listbox by text ascending (sort tab in list box properties)?

If this does not work, how have you created the field and what sort options are currently enabled?

tulasiram_bitra — Wed, 06 Jan 2016 09:34:43 GMT

Hi Swuehl,

Sorry for late reply.

I have written expression in listbox like ='Wk- '&Week.

Sort options are Numeric Value -- Ascending

And I tried Sort => Text -- Ascending also.

But I didn't get solution. Please let me know

sunny_talwar — Wed, 06 Jan 2016 11:17:33 GMT

Try sorting using the expression and input =Week in there and see if that works:

Wed, 06 Jan 2016 11:32:53 GMT

Hi Ram,

Can you attach the sample application for this ? . We can achieve this using expression under sort tab .