How to adjust dimension over expression in pivot table??

[sushil353]

Hi All,

I have a pivot table in which two dimensions are there 1. Location Desc and 2. Defect type

also in the same table two expression is calculated 1.defect_op_yield_summary and 2. Op_defect_summary

I want to adjust defect_type dimension over op_defect_summary column only...

I am attaching the qlikview file... when i am trying to put defect_type dimention in horizontal then it is applied to both expressions..but i want to put dimention over op_defect_summary type only...

Please help me out .... as client want to see the report only that way....

[sushil353]

Please help me guys

[#3]

Will this work for u.

[sushil353]

Hi Erika,

Thanks for your effort.. but in your solution this is fixed for two defect type only... orginally i have 1000 of defect type and they are dependent on location as well..

it should be dynamic kind of table.

Thanks

[sushil353]

any idea please share..

[SunilChauhan · Accepted solution]

remove it from expression and add into dimension using fomula below

aggr(sum({$<source={'defect_yield_op_type_summary'},defect_type=>}total_defects),location_descr)

see the attached file also

[sushil353]

Thanks Sunil