Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please help me out in above query asked.
Regards,
Gunjesh
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
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
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
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 )
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