Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
alex-wb
Contributor III
Contributor III

Sorting Axis for dual plots

Hi All,

I have plotted two 52 week periods that role every time a new week is started.  The code for it is

Current 52  week period:

Count({$<Fault_Received_Day={">=$(=WeekEND(max(Fault_Received_Day),-105,))<=$(=WeekEND(max(Fault_Received_Day),-53))"}
>}Fault_Ref)

Previous 52 week period:

Count({$<Fault_Received_Day={">=$(=WeekEND(max(Fault_Received_Day),-105,))<=$(=WeekEND(max(Fault_Received_Day),-53))"}
>}Fault_Ref)

The axis plot is Week(FAULT_RECEIVED_DAY) As FR_Week,

I can't seem to sort the calendar to be in the correct order which would be 47,48,49,50,51,52,1,2,3,4 and I also want to reduce it to just 52 weeks. Is this something I will need to fix in the data load editor?

Thanks,

Alex 

alexwb_0-1637767025315.png

 

 

0 Replies