Average %

[qlikviewaf]

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!

[Anonymous]

Hi,

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

[Anil_Babu_Samineni]

Better, If you provide sample application?

[sunny_talwar]

What is your expression for the chart?

[passionate]

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

[passionate]

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

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