If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I want to show a dynamic daily deviation from the average
Every day there is a certain quantity entering production, I need to show that quantity less the avg quantity of the selected period.
for example i chose the past week, the week avg is 54
so in a bar chart for every day i should get that day sum of quantity less 54
if no time period was selected, it should show the sum of each day less the total avg.
when i try to do so in a bar chart i get all 0 (it calculates the sum and avg on every day)
Something along the lines of:
Should get you the daily average across all selections, I think.
View solution in original post
Thank you @Or !!