How to get the correct value with average function?
I have a problem with function Avg(), due to I can´t get the real value when I try to use it.
I have a table in excel like this:
I need to calculate the average time for each vacancy and display it for each Analist. In excel, I can get the table with these data (I use formule of course) and obtain the exactly values, but when I try to do in Qlik, the average isn't correct.
I obtain the time response like this: DATE FINISH - DATE REQ. If I want to get the time average in Qlik, I just select the pivot table with this data:
Dimension: Year, Vacancy
Measure: Avg([TIME RESPONSE])
My pivot table looks like this:
Here's the problem...the results in Qlik are very different when I use Average function
So, I don't know how obtain the same results in both Qlik and Excel.