Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

show previous weeks data based on selection

I have the below expressions that I want to plot on a graph (it returns an amount of time). I want the graph to plot the Maximum available "Week" (which is a field in my table) and then the previous n weeks (will probably be 13 but I should be able to change it in the expression)

sum(if(Left(TaskType,4)='PACK',WorkTimeAverage))/sum(if(Left(TaskType,4)='PACK',LineQty))

0 Replies