Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with sort in a table


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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
bbi_mba_76
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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

Not applicable
Author

Thanks for your help it works