Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
caccio88
Creator II
Creator II

Filtering a Pivot Table

Hi guys,

i'm just wondering if someone could help me.

I want to filter values of an expression in a pivot table.

Maybe is it possible to create a new dimension?

The values that I want to filter is in the column "Check" in the pivot table.

I attach here the example.

Thank you so much.

1 Solution

Accepted Solutions
qlikmsg4u
Specialist
Specialist

You can follow the same process suggested by tresesco

but in multibox > expression > Paste the expression and Name it to Check

Capture.PNG

View solution in original post

8 Replies
caccio88
Creator II
Creator II
Author

tresesco‌ could u help me please?

tresesco
MVP
MVP

Not sure what you are looking for. Are you trying to have all OKs and remove NOs? You have to explain a bit more.

caccio88
Creator II
Creator II
Author

Yep. That's right. I'd like to be able to filter the value of "Check" that as u can see are "OK" or "NO".

I'm wondering if it's possible to creata "Check" like a dimension where I can choose to sign "OK" or "NO".

Do u need more information?

Let me modify and upload here a new version a little bit more accurate.

tresesco
MVP
MVP

Take a listbox, go to expression (in the Field drop down); try expression like:

=Aggr( <Your expression in the piviot table> , [Business Unit ID])

caccio88
Creator II
Creator II
Author

Not yet what I'm looking for.

The target would be to have "Check" as a dimension in "Filter by", where I can choose only "OK" or "NO"...

qlikmsg4u
Specialist
Specialist

You can follow the same process suggested by tresesco

but in multibox > expression > Paste the expression and Name it to Check

Capture.PNG

caccio88
Creator II
Creator II
Author

Thank u both!!! Now I've hit my goal! so grateful!

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Check This :

Just Goto Properties>>>Sort>>Enable Y-value>>assenting Order.