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

[gunjesh0310]

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

Please help.Its urgent.

Regards,

Gunjesh

[gunjesh0310]

Hi,

Please help me out in above query asked.

Regards,

Gunjesh

[qliksus]

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

[gunjesh0310]

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

[gunjesh0310]

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

[qliksus]

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 )

[gunjesh0310]

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