topic Re: Weekday in QlikView

Weekday

Thu, 20 Feb 2014 14:40:08 GMT

Hi all,

I made the following list box:

Weekday:

mo tu ...... sun

It just works fine it gives me the results I want when i select a day, however when I select Tuesday for instance it puts Tuesday on the beginning or the end of the line:

Tuesday, wednesday thursday friday saturday sunday

or friday:

Friday mo, tue, wed, thu, sa, su

Is there someway to just lock it? Like when i select tuesday it doens't pop to the beginning or the end of the line.

It just keeps in chronological order no matter what day I select.

Moday-Sunday

my script for weekday:

LOAD * INLINE [

PerformanceWeekday, Sort

mo, 1

tu, 2

we, 3

th, 4

fr, 5

sa, 6

su, 7

];

kind regards

Re: Weekday

alexandros17 — Thu, 20 Feb 2014 14:42:25 GMT

Probably you used an expression in your list box, fix it computing that exprression in the script and use the nuew field. it should work

Re: Weekday

Thu, 20 Feb 2014 14:43:01 GMT

If you go to the properties of your listbox > Sort : deselect the Status option.

This should solve it.

Re: Weekday

Thu, 20 Feb 2014 14:43:37 GMT

In the list box, sort tab

uncheck the sort by state

keep sort by load order

Fabrice

Re: Weekday

Thu, 20 Feb 2014 14:50:27 GMT

if I deselect everything my week isn't in the correct line up

(mo-sun)

however then it does lock and isn't moving when I select a day

Re: Weekday

Thu, 20 Feb 2014 14:52:27 GMT

you could try to sort by expresion.

sum(Sort)

or sort by load order

Re: Weekday

jpapador — Thu, 20 Feb 2014 14:53:17 GMT

O the sort tab, uncheck sort by state as others have suggested. Then in the Expression box (on the sort tab) manually sort them like:

Match(WeekDay, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun')

make sure to check the expression check box.

Re: Weekday

Thu, 20 Feb 2014 14:56:15 GMT

thanks Jelco!

Thanks for all the suggestions people 😃