topic Re: Problem with sort in a table in QlikView

Problem with sort in a table

Mon, 26 Jan 2026 16:26:21 GMT

Hello everybody,

I have a problem with sort in a table. I want to sort a week as dimension in a table ascending. I sort about the fomula. The Problem is now that thef first week I want to see in the Table stand on a other position. What can I do? For example I attach a sample.

greetings Sven

Re: Problem with sort in a table

Gysbert_Wassenaar — Wed, 23 Oct 2013 12:40:32 GMT

Try sorting by this expression: BUSINESS_PLAN.REQUIRED_DATE_YEAR*100+BUSINESS_PLAN.REQUIRED_DATE_WEEK

Re: Problem with sort in a table

bbi_mba_76 — Wed, 23 Oct 2013 12:43:03 GMT

Hi,

this could work, in the calculated dimension:

=if(BUSINESS_PLAN.REQUIRED_DATE>=vStartBP and

BUSINESS_PLAN.REQUIRED_DATE<=vEndDateForecast2,dual('KW' & BUSINESS_PLAN.REQUIRED_DATE_WEEK,BUSINESS_PLAN.REQUIRED_DATE_WEEK))

and then sort bereich by numeric

Re: Problem with sort in a table

Wed, 23 Oct 2013 12:53:49 GMT

The idea is good but the problem is the week 1 is the first week of 2014. So the week must follow the week 51.

Thanks for your help

Re: Problem with sort in a table

Wed, 23 Oct 2013 12:55:23 GMT

Thanks for your help it works