Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
irmantas
New Contributor III

Re: PivotTable exlude Dimensions from filter

try select ex. Z-GPS-GRANU in ItemId filter. In first PivotTable we see sum of Z-GPS-GRANU QTY were TransType=1, and Aggr of QTY were this RefId and TransType=2

in red square I want to see Pivot detailed Aggr function, all items were TransRefId the same as Z-GPS-GRANU, but TransType=2

vishsaggi
Esteemed Contributor III

Re: PivotTable exlude Dimensions from filter

NOt sure i understood your requirement sorry. Can you tell what is that you want to see in your other Pivot when you select an item?

irmantas
New Contributor III

Re: PivotTable exlude Dimensions from filter

Maybe the visual will be clearer?

irmantas
New Contributor III

Re: PivotTable exlude Dimensions from filter

Can no one help me? Did I explain the task vaguely?