topic PivotTable exlude Dimensions from filter in QlikView

PivotTable exlude Dimensions from filter

irmantas — Thu, 27 Sep 2018 11:04:07 GMT

Hello,

How to create second Pivot table in same document, and show list dimensions with excluding of filtering and first PivotTable.

How I can create other Pivot Table were show all ItemId were TransType=2 and excluding ItemId filter.

Re: PivotTable exlude Dimensions from filter

dplr-rn — Thu, 27 Sep 2018 18:41:16 GMT

First of all use set analysis instead of the if statements much faster and more flexible. check below link and tons of other videos for it

A Primer on Set Analysis

Sum({<TransType={1}>} Qty)

If you use set analysis you can ignore selections if needed

Sum({1<TransType={2}>} Qty)

here 1 ignores all selections

Re: PivotTable exlude Dimensions from filter

irmantas — Thu, 27 Sep 2018 19:23:10 GMT

If I using Sum({1<TransType={2}>} Qty), I see all Items were TransType=2, but I need get only these were TransType=2 and RefId= RefId of Item selected in filter

Re: PivotTable exlude Dimensions from filter

dplr-rn — Thu, 27 Sep 2018 19:39:18 GMT

So you need to ignore just ItemId? if so

Sum({<ItemId=,TransType={2}>} Qty)

Re: PivotTable exlude Dimensions from filter

irmantas — Thu, 27 Sep 2018 19:52:02 GMT

That OK to ignore just ItemId, but I still need relation over RefId. I want sum only Qty of All Items, were RefId is the same as selected in filter Item.

Re: PivotTable exlude Dimensions from filter

dplr-rn — Thu, 27 Sep 2018 19:54:37 GMT

not sure i understand. if selected in filter that selection should be applied.

share a sample app if possible

Re: PivotTable exlude Dimensions from filter

vishsaggi — Thu, 27 Sep 2018 22:25:46 GMT

can you share a sample to look into?

Re: PivotTable exlude Dimensions from filter

irmantas — Fri, 28 Sep 2018 06:45:18 GMT

here we go

Re: PivotTable exlude Dimensions from filter

irmantas — Mon, 01 Oct 2018 10:39:06 GMT

Does some one have any ideas?

Re: PivotTable exlude Dimensions from filter

vishsaggi — Mon, 01 Oct 2018 14:52:57 GMT

Can you tell me your expected output value based on your attached sample?

Re: PivotTable exlude Dimensions from filter

irmantas — Tue, 02 Oct 2018 10:50:40 GMT

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

Re: PivotTable exlude Dimensions from filter

vishsaggi — Tue, 02 Oct 2018 18:56:43 GMT

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?

Re: PivotTable exlude Dimensions from filter

irmantas — Wed, 03 Oct 2018 07:04:21 GMT

Maybe the visual will be clearer?

Re: PivotTable exlude Dimensions from filter

irmantas — Mon, 08 Oct 2018 10:42:05 GMT

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