Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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