Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
marjan_it
Contributor III

How to get average of two dimention in chart?

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?

8 Replies
rohitlohani
New Contributor III

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

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

vvvvvvizard
Contributor III

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

Try clicking on the cyclical group to view both views

stabben23
Honored Contributor

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

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.

marjan_it
Contributor III

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

No Its not my purpose

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

stabben23
Honored Contributor

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

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

marjan_it
Contributor III

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

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.

stabben23
Honored Contributor

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

Then you have to remove region as dimension

marjan_it
Contributor III

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

I want to get average from 2 dimensions