topic Re: Dynamic average in QlikView

Dynamic average

Zaga_69 — Fri, 08 Feb 2019 18:14:40 GMT

Hi guys 🙂

I am trying to create a line reference in a bar chart. This line reference should calculate the average of total purchases depending on the year selected.

I tried sth like this:

=Avg({<CostElement={'0006000901', '0006014900'}>} sum(amount) )

However it does not work

Any idea,

BR,

Edi

Re: Dynamic average

forticarrion — Fri, 08 Feb 2019 18:37:57 GMT

Hello,

I created two combo charts whit this example, take a look.

Re: Dynamic average

pradosh_thakur — Fri, 08 Feb 2019 21:13:51 GMT

I cant open your qvw . Can you try the below , changed a few things in your expression
=Avg({<CostElement={0006000901, 0006014900},Year=$::Year>} amount )

Re: Dynamic average

Zaga_69 — Mon, 18 Feb 2019 21:14:25 GMT

Hi Pradosh

firstly, thank you for your answer and sorry for my late reply.

I will try it and will let you know if it works,

Best regards,

Edi