topic Re: Average % in QlikView

Average %

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have this table below on my Qlik report.

I would like to calculate the average YTD difference by AREA (Emea and APAC/LATM) and then I would like to add an up pointing arrow if YTD diff is positive, an down pointing arrow if the YTD diff is negative.

How this can be done? Using which function?
Thank you!

Re: Average %

Anonymous — Tue, 20 Jun 2017 10:57:55 GMT

Hi,

You can use the AVG function with the aggr function in your set analysis

Re: Average %

Anil_Babu_Samineni — Tue, 20 Jun 2017 10:58:24 GMT

Better, If you provide sample application?

Re: Average %

sunny_talwar — Tue, 20 Jun 2017 11:10:24 GMT

What is your expression for the chart?

Re: Average %

passionate — Tue, 20 Jun 2017 11:15:16 GMT

Hi Antonio,

In you Expression tab you can add one more expression like:

-if(expression >0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

-Select type of expression as image

-Select keep aspect.

Regards,

Pankaj

Re: Average %

passionate — Tue, 20 Jun 2017 11:17:09 GMT

Arrow options like: qmem://<bundled>/BuiltIn/arrow_n_g.png used above

This option you can find in Expression->Images->Advanced tab