Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal will move to Qlik Community Oct 4. Temporary case outage Oct 3. READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Rolling Week Sorting in Qlik

Hi All , I have a issue in sorting week field in chart level like line and bar.

For example i have chart with 12 rolling weeks, if i dont select my sorting is working file because all the weeks are in 2019 so no issue in sorting but if select 8 week of 2019 , it has to show from 2018 50 week to 8th week of 2019 then sorting is not working if i create unique number also.

 

Can anyone try and tell me the solution for this to solve on my sample data

 

Dim: Week

Expression: Sum(Sales)

Chart : Bar or Line

 

Thank you in advance.

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Sort order on week using expression  =min({<Week>}[Week Sorting])

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

9 Replies
kaushiknsolanki

Hi, Can you share sample app which shows your issue.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Vegar
MVP
MVP

Try Sum( {<Year, Week, [Week Sorting]={">=$(=MAX([Week sorting])-12) < $(=MAX([Week sorting]))"}
>}
Sales)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
subbareddykm
Creator II
Creator II
Author

App is attached in this. Here is simple example it shows that issue
subbareddykm
Creator II
Creator II
Author

 
subbareddykm
Creator II
Creator II
Author

Not working Vegar

tresesco
MVP
MVP

Try to share your sample app (not screen shot) where we can check the issue and help fix it for you.
Vegar
MVP
MVP

I had a typo "sorting" should be "Sorting" (typing on my mobile). See attached application.

 

 

Sum( {<
   Year, 
   Week, 
   [Week Sorting]={">=$(=MAX([Week Sorting])-12)< $(=MAX([Week Sorting]))"}
>}
Sales)

 

12months figures over Year and Month12months figures over Year and Month

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
subbareddykm
Creator II
Creator II
Author

Hi Tresesco,

 

Thanks for the response, file is attached

Vegar
MVP
MVP

Sort order on week using expression  =min({<Week>}[Week Sorting])

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post