# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New Contributor II

## Need to add Custom in report and Average of 6,9,12 Month

Hi,

I am facing two issue  in qlikview report.

1. to add custom object in a table.(Please see below table i.e. third column i.e. AVG 12M,AVG 9M,AVG 6M).

 Product QTY Custom Dimension Avg Consumption Sales A 10 AVG 12M [trans QtY]/12 100 B 12 AVG 9M [trans QtY]/9 500 c 13 AVG 6M [trans QtY]/6 600

2. How to calculate Average of 12 month,6 month,9 month of [Trans QTY] (please see above table column [AVG Consumption i.e.[trans QtY]/12] ).

Regards,

Gunjesh

Tags (1)
6 Replies
Highlighted
New Contributor II

## Re: Need to add Custom in report and Average of 6,9,12 Month

Hi,

Regards,

Gunjesh

Highlighted
Valued Contributor II

## Re: Need to add Custom in report and Average of 6,9,12 Month

Hi ,

Just create 3 expressions for average in the pivot table and drag it to the dimension

Dim1 : Product

Dim2 : aggr( sum(sales) , Product )

Expr  : 3 average expression

Highlighted
New Contributor II

## Re: Need to add Custom in report and Average of 6,9,12 Month

Hi,

But How the AVG 12M,AVG 9M,AVG 6M will come in rows?

AVG 12M

AVG 9M

AVG 6M

Pls Help.

Regards,

Gunjesh Joshi

Highlighted
New Contributor II

## Re: Need to add Custom in report and Average of 6,9,12 Month

Hi,

I tried convert column to row of Average column,But there are 5-6 more measure columns,they are also coming as rows.

But I need only these three measure expression as rows i.e.

Avg 12M

AVG 9M

Avg 6M

Highlighted
Valued Contributor II

## Re: Need to add Custom in report and Average of 6,9,12 Month

Use the other Measure as calculated dimension and use only the Avg12,6,9 in the expression . Something like the below

Dim2 : aggr( sum(sales) , Product )

Highlighted
New Contributor II

Hi,