topic Re: How to get average of two dimention in chart? in QlikView

How to get average of two dimention in chart?

marjan_it — Wed, 17 Jan 2018 06:09:34 GMT

Hi All

I have a line chart with 2 dimention month and region. and an expression average of data like below. I want to have an average line that be average of each region in each month.what should I do to get this?

Re: How to get average of two dimention in chart?

Anonymous — Wed, 17 Jan 2018 06:53:39 GMT

hello marjan ,

we have function called column by using columns function achieved ur desired result.\

for eg

column(1)+column(2)/2

kindly try this in ur app

Thanks and regards,

Rohit lohani

Re: How to get average of two dimention in chart?

vvvvvvizard — Wed, 17 Jan 2018 07:13:26 GMT

Try clicking on the cyclical group to view both views

Re: How to get average of two dimention in chart?

stabben23 — Wed, 17 Jan 2018 07:15:21 GMT

Hi,

in Your example data, you only have one region on each month. So if you use sum or avg as Expression doesent change anything here. Your linechart is showing you an average on each region on each month. If you add one more value for example on region 01 on month 1, then avg(Data) will gives you average for thoose 2 values on month 1.

otherwise give us some example on expected output.

Re: How to get average of two dimention in chart?

marjan_it — Wed, 17 Jan 2018 07:22:02 GMT

No Its not my purpose

I want average of all region in each moth month. It should be a broken line.

Re: How to get average of two dimention in chart?

stabben23 — Wed, 17 Jan 2018 07:36:16 GMT

I dont get it, but try if this Expression gives you correct output avg(total <region>Data)

Re: How to get average of two dimention in chart?

marjan_it — Wed, 17 Jan 2018 07:39:38 GMT

Yes Its correct. But I want an average line that show average of all region in each month.for example average in month1 will be 266 and the average in month 2 will be 339.

Re: How to get average of two dimention in chart?

stabben23 — Wed, 17 Jan 2018 07:45:55 GMT

Then you have to remove region as dimension

Re: How to get average of two dimention in chart?

marjan_it — Sat, 20 Jan 2018 07:11:51 GMT

I want to get average from 2 dimensions