Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregation - Percentages Average

Hi All,

I am in trouble and struggling with designing an expression which seems to me pretty simple, but in fact, I was able to write it down as expected.

Let me show you the scenario:

pivot.png

So, I have that for each date, I calculate the avg value and calculate a percentage of "improvement" of the value, following this formula: input-output/input*100.

This works fine when I have the Date Dimension (as in the picture). But I want to remove it and calculate an average of the formula (input-output/input*100). I do not want avg(input)-avg(output)/avg(input)*100, but the percentage average.

May you please help me to reach this goal? How can this be done?

Thanks in advance for your help!! 

2 Replies
Not applicable
Author

None has any idea about how to do this?

Thanks for your suggestions!

maxgro
MVP
MVP

could you post your data?