Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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?