Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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
Please help me guys
Will this work for u.
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
any idea please share..
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
Thanks Sunil