topic How to adjust dimension over expression in pivot table?? in QlikView

How to adjust dimension over expression in pivot table??

sushil353 — Thu, 08 Sep 2011 11:16:56 GMT

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

How to adjust dimension over expression in pivot table??

sushil353 — Thu, 08 Sep 2011 11:48:58 GMT

Please help me guys

Re: How to adjust dimension over expression in pivot table??

Thu, 08 Sep 2011 12:01:14 GMT

Will this work for u.

How to adjust dimension over expression in pivot table??

sushil353 — Fri, 09 Sep 2011 05:18:53 GMT

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

How to adjust dimension over expression in pivot table??

sushil353 — Fri, 09 Sep 2011 07:38:35 GMT

any idea please share..

Re: How to adjust dimension over expression in pivot table??

SunilChauhan — Fri, 09 Sep 2011 08:01:27 GMT

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

How to adjust dimension over expression in pivot table??

sushil353 — Fri, 09 Sep 2011 10:13:39 GMT

Thanks Sunil