This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi, I am trying to build a bar chart with average sales per day of the week for the chosen period, but my formula returns Sales (not Average sales). What is wrong? Thank you!
aggr( Sum(Sales), [DayOfWeek_Field] )
May be like this
View solution in original post
maybe, as dimension, put DayOfWeek_Field and as a measure:Avg(Sales)?
Are you doing this in a text box object or a table?
That's right... just totally ignored the title of the post
it's not working
What do you excpect as a result?
Average sales by day of week:
If i choose March, it should return Sum(<Monday> Sales)/count(<Monday> DaysOfWeek) and put it in the first Bar.
BTW, this works form me - I just wanted to apply a nicer solution.
I think I got the logic.
I tried to split by DayOfWeek in the formula but as long as it is already done by setting a Dimension, the [Date] field in the formula will suffice.