topic Re: Count Avg from Chart in QlikView

Count Avg from Chart

rmdnkevin — Thu, 05 Jul 2018 04:09:38 GMT

Hi, everyone.

I have 2 charts like this :

Those 2 charts are the result of computation from this chart :

What I want to ask is, how can I count the average over 5 months of Simulation Clicked and Report-to-Click Ratio ?

Any answer would be greatly appreciated

Thank you

- Kevin

Lisa_P — Thu, 05 Jul 2018 04:26:42 GMT

Whatever your expression is to create the bar chart, you will need to use the aggr function to aggregate by the dimension in your chart.

If your dimension is month, then it would look like this:

Avg(Aggr(........... , Month))

rmdnkevin — Thu, 05 Jul 2018 04:38:46 GMT

Great !

Beside that, can you help to make a summary table from Click & Report Rates and Report-to-Click Ratio charts ?

Lisa_P — Thu, 05 Jul 2018 04:42:05 GMT

You could either copy and paste and convert to a table or toggle between the two using the Fast change option.