topic Re: Average value in barchart in QlikView

Average value in barchart

stekol61 — Wed, 29 Mar 2017 14:03:36 GMT

Hi!

The enclosed .qvw has a simple barchart.

What I want is that the red bar always show the avaerage value for the selected period.

It should reflect the changes of "Node" and/or "Technology" but not changes of "Date(s)"

How can this be done?

Re: Average value in barchart

sunny_talwar — Wed, 29 Mar 2017 14:11:28 GMT

May be this?

Sum({<Date>}[Period Duration]/1440)

Re: Average value in barchart

stekol61 — Wed, 29 Mar 2017 14:24:49 GMT

Sum({<Date>}[Period Duration]/1440)

seems to give a totlal value for the period.

What I need is an average value for the period. Changing "Sum" to "Avg" doesb't seem to help.

The correct value for node "B" and Technology "4G" should be around 29000

Re: Average value in barchart

sunny_talwar — Wed, 29 Mar 2017 14:27:38 GMT

May be try this

Avg({<Date>}Aggr(Sum({<Date>}[Period Duration]/1440), Date, Technology, Node))

Re: Average value in barchart

stekol61 — Wed, 29 Mar 2017 14:36:02 GMT

Grate!.

This solved my problem

Re: Average value in barchart

sunny_talwar — Wed, 29 Mar 2017 14:46:49 GMT

I helped resolved and I get neither correct, nor helpful response .... Just kidding, but jokes apart, it would make sense to mark true correct and helpful responses for future users.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny