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
Highlighted
irmantas
New Contributor III

PivotTable exlude Dimensions from filter

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.

13 Replies
Partner
Partner

Re: PivotTable exlude Dimensions from filter

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

irmantas
New Contributor III

Re: PivotTable exlude Dimensions from filter

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

Partner
Partner

Re: PivotTable exlude Dimensions from filter

So you need to ignore just ItemId? if so

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

irmantas
New Contributor III

Re: PivotTable exlude Dimensions from filter

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.

Partner
Partner

Re: PivotTable exlude Dimensions from filter

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

share a sample app if possible

vishsaggi
Esteemed Contributor III

Re: PivotTable exlude Dimensions from filter

can you share a sample to look into?

irmantas
New Contributor III

Re: PivotTable exlude Dimensions from filter

here we go

irmantas
New Contributor III

Re: PivotTable exlude Dimensions from filter

Does some one have any ideas?

vishsaggi
Esteemed Contributor III

Re: PivotTable exlude Dimensions from filter

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