Sort by Expression

[Anonymous]

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

[amit_saini]

Adrian,

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

Thanks,

AS

[tresesco]

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

[Anonymous]

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

[Anonymous]

I've tried that too with the same result

[IAMDV]

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,

DV

www.QlikShare.com

[tresesco]

try to share your sample qvw.

[MK_QSL]

Like this ?

[Anonymous]

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. ?????????

[tresesco]

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