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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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