Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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!! 

Tags (2)
2 Replies
Not applicable

Re: Aggregation - Percentages Average

None has any idea about how to do this?

Thanks for your suggestions!

MVP
MVP

Re: Aggregation - Percentages Average

could you post your data?