Hi, that expression works for my example...but how could apply that concept in my excel file (attach) -it's in spanish but the idea is the same-. I want to provide this example:
Month Analist Seller 30 Jan Carl Seller 52 Jan Carl Seller 15 Jan Carl Seller 40 Jan Fred Seller 22 Jan Fred Seller 12 Feb Carl Seller 10 Feb Fred Seller 30 Feb Fred
Average time response for January / Seller / Carl: 32,33
Average time response for January / Seller / Fred: 31,00
Average time response for January / Seller : average(32,33;31) -->31,66
Average time response for Febrary/ Seller / Carl: 12
Average time response for Febrary/ Seller / Fred: 20
Average time response for Febrary / Seller : average(12;20) -->16
If I want to create an average for Jan-Feb in a excel, the table looks like this
Carl Fred Time Response Average Seller =average(Jan;Feb) =average(Jan;Feb) =average(Carl_Seller; Fred_Seller) Carl Fred Time Response Average Seller 22,16 25,5 23,83
So, when I try to reply this calculation in Qlik Sense (I use your expression), the result it's different to my file (attach)
I need to do this for compare 2 years (2016-2017) per Analist per Vacancy (like pivot table). Maybe I have been doing something wrong, but I can't found it.
I hope that my question can be solution.
TimeResponse.xlsx 371.1 K