topic Re: Calculated Average Dimension in QlikView

Calculated Average Dimension

bazzaonline — Mon, 06 Oct 2014 13:39:50 GMT

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???

anbu1984 — Mon, 06 Oct 2014 14:00:48 GMT

Check this

bazzaonline — Mon, 06 Oct 2014 14:18:36 GMT

?? What ??

wernerprovelu — Mon, 06 Oct 2014 14:21:00 GMT

Or use set analysis:

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

anbu1984 — Mon, 06 Oct 2014 14:29:52 GMT

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

Re-attaching qvw

jyothish8807 — Mon, 06 Oct 2014 14:44:01 GMT

Hi Paul,

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

1. Avg(Amt)

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

Regards