Discussion Board for collaboration related to QlikView App Development.
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).
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.
Please help me out in above query asked.
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
Thanks for reply.
But How the AVG 12M,AVG 9M,AVG 6M will come in rows?
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.
Use the other Measure as calculated dimension and use only the Avg12,6,9 in the expression . Something like the below
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.