Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

bazzaonline
New Contributor III

Calculated Average Dimension

Hello All,

I would like to draw a graph which has two average lines on.  One a simply average invoice amount per month - eg =Avg(InvoiceAmount)

The second I want to be the average invoice amount except for ones of £25.  (so to not include invoices for a £25 fee only).

EG - Invoice 1 - £100, Invoice 2 - £80, Invoice 3 - £25 = ( £100 + £80 ) / 2 = £90.

Any help welcomed???

Tags (1)
5 Replies
anbu1984
Honored Contributor III

Re: Calculated Average Dimension

Check this

bazzaonline
New Contributor III

Re: Calculated Average Dimension

??  What ??

wernerprovelu
New Contributor II

Re: Calculated Average Dimension

Or use set analysis:

Avg({<Amt = -{25}>} Amt)

anbu1984
Honored Contributor III

Re: Re: Calculated Average Dimension

There is prob in community. I attached qvw in my previous post which I can see it.

Re-attaching qvw

jyothish8807
Honored Contributor II

Re: Calculated Average Dimension

Hi Paul,

Go to presentation tab.In reference line option add two expression.

1. Avg(Amt)

2 Avg({Amt-={'25'}>}Amt)

Regards

KC

Best Regards,
KC
Community Browser