topic Re: Sort by Expression in QlikView

Sort by Expression

Anonymous — Wed, 18 Jun 2014 07:38:44 GMT

I want my list box to show calendar week numbers in order no matter what selections have been made. The financial year runs from calendar week 19 to 18. I have field for Week (Calendar week numbers) and also WeekID (Financial Week numbers)

Week WeekID

19 1

20 2

21 3

etc...

16 50

17 51

18 52

When I am sorting in the Week List Box the expression I am using is

Only ( {1} TOTAL WeekID)

but this doesn't work. Please help

Re: Sort by Expression

amit_saini — Wed, 18 Jun 2014 07:40:10 GMT

Adrian,

Do you want to show only week 18 and 19 always???

Thanks,

Re: Sort by Expression

tresB — Wed, 18 Jun 2014 07:41:48 GMT

Try without 'total', like: =Only ( {1} WeekID)

Re: Sort by Expression

Anonymous — Wed, 18 Jun 2014 07:42:16 GMT

I want the list box to show all 52 weeks running from week 19 to week 18 at all times no matter what selections have been made

Re: Sort by Expression

Anonymous — Wed, 18 Jun 2014 07:42:39 GMT

I've tried that too with the same result

Re: Re: Sort by Expression

IAMDV — Wed, 18 Jun 2014 08:03:01 GMT

Hi Adrian,

See the attachment.

In this kind of situations, I prefer to rely on Load Order. Generally, QlikView will remember the first load order if the field names are same. So I suggest load your [Week] field in whatever order you prefer and then reload your Fact table data. Then check only "Load Order" option under sorting tab.

I hope this helps!

Cheers,

www.QlikShare.com

Re: Sort by Expression

tresB — Wed, 18 Jun 2014 08:06:27 GMT

try to share your sample qvw.

Re: Sort by Expression

MK_QSL — Wed, 18 Jun 2014 08:14:13 GMT

Like this ?

Re: Sort by Expression

Anonymous — Wed, 18 Jun 2014 08:58:47 GMT

Yes, that is what I want to show but I have tried sorting it in the same as in your sample app and I get the weeks running from 1 to 52 not 19 to 18. ?????????

Re: Sort by Expression

tresB — Wed, 18 Jun 2014 09:01:54 GMT

So, it has to be something specific to your app. Share your sample app, see: Preparing examples for Upload - Reduction and D... | Qlik Community