topic Re: Filtering a Pivot Table in QlikView

Filtering a Pivot Table

caccio88 — Tue, 22 Sep 2015 15:35:51 GMT

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.

caccio88 — Wed, 23 Sep 2015 08:08:18 GMT

tresesco‌ could u help me please?

tresB — Wed, 23 Sep 2015 08:16:32 GMT

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 — Wed, 23 Sep 2015 08:50:07 GMT

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.

tresB — Wed, 23 Sep 2015 09:01:06 GMT

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 — Wed, 23 Sep 2015 09:10:30 GMT

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 — Wed, 23 Sep 2015 09:16:10 GMT

You can follow the same process suggested by tresesco

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

caccio88 — Wed, 23 Sep 2015 09:29:39 GMT

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

nagarjuna_kotha — Wed, 23 Sep 2015 09:31:50 GMT

Check This :

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