Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

subbareddykm
Contributor 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
Partner
Partner

Re: Rolling Week Sorting in Qlik

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

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
9 Replies

Re: Rolling Week Sorting in Qlik

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

Regards,

Kaushik Solanki

Partner
Partner

Re: Rolling Week Sorting in Qlik

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

Re: Rolling Week Sorting in Qlik

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

Re: Rolling Week Sorting in Qlik

 
subbareddykm
Contributor II

Re: Rolling Week Sorting in Qlik

Not working Vegar

MVP
MVP

Re: Rolling Week Sorting in Qlik

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

Re: Rolling Week Sorting in Qlik

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)

 

image.png12months figures over Year and Month

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
subbareddykm
Contributor II

Re: Rolling Week Sorting in Qlik

Hi Tresesco,

 

Thanks for the response, file is attached

Partner
Partner

Re: Rolling Week Sorting in Qlik

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

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes