Qlik Community

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).

ProductQTY  Custom DimensionAvg ConsumptionSales
A10  AVG 12M[trans QtY]/12100
B12  AVG 9M[trans QtY]/9500
c13 AVG 6M[trans QtY]/6600

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] ).

Please help.Its urgent.

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,

Please help me out in above query asked.

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,

Thanks for reply.

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

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

Hi,

Thanks for reply.

But my problem is I am using set analysis in other expression and  I think we can't use set analysis in calculated dimension,But in other measures we are having set analysis written.

Regards,

Gunjesh Joshi