Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
Honored Contributor II

How to adjust dimension over expression in pivot table??

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

1 Solution

Accepted Solutions
chauhans85
Esteemed Contributor

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

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

6 Replies
sushil353
Honored Contributor II

How to adjust dimension over expression in pivot table??

Please help me guys

Not applicable

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

Will this work for u.

sushil353
Honored Contributor II

How to adjust dimension over expression in pivot table??

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
Honored Contributor II

How to adjust dimension over expression in pivot table??

any idea please share..

chauhans85
Esteemed Contributor

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

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
Honored Contributor II

How to adjust dimension over expression in pivot table??

Thanks Sunil

Community Browser