Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
roisolberg
Creator
Creator

Daily Sum - Daily Average on bar chart (daily deviation from avg)

Hi All,

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)

DailyEntries.JPG

DailyEntries_Selection.JPG

Any ideas?

Thanks,

Roi

Labels (3)
1 Solution

Accepted Solutions
Or
Champion
Champion

Something along the lines of:

Avg(total Aggr(Sum(Sales),EntryDate))

Should get you the daily average across all selections, I think.

View solution in original post

2 Replies
Or
Champion
Champion

Something along the lines of:

Avg(total Aggr(Sum(Sales),EntryDate))

Should get you the daily average across all selections, I think.

roisolberg
Creator
Creator
Author

Thank you @Or !!

Working perfectly