topic Filter Pivot Table without user making a Selection in QlikView

Filter Pivot Table without user making a Selection

Mon, 21 Mar 2011 16:56:34 GMT

I am looking to create either a table or pivot table for checking stock conditions of manufactured "M" or bought out parts "B"

Is there a way to filter the table permanently so that it always only displays "B" items or "M" items regardless of any other selections made in the sheet.

thanks

Filter Pivot Table without user making a Selection

matt_crowther — Mon, 21 Mar 2011 17:27:00 GMT

Add a 'Calculated Dimension' under the dimensions tab of the Straight Table along the lines of the following:

=if(Item_Name='B' or Item_Name='M',Item_Name)

Then check the 'Supress Where Value is Null' check box.

That method works for me.

Hope that helps,

Matt - Visual Analytics Ltd

Filter Pivot Table without user making a Selection

Mon, 21 Mar 2011 17:34:49 GMT

Hi not quite what I need I don't believe, can I get it to show only the 'B' items for example without any selections being made.

Filter Pivot Table without user making a Selection

matt_crowther — Mon, 21 Mar 2011 17:44:01 GMT

Here's what the posted formula should be doing - with NO selections:

The first is a simple Straight Table with 'Name' as the dimension - all 'Name' values are returned as lon gas they have a sale against them.

In the second I've added a Caluculated Dimension =if(left(name,1)='P',Name) - no selections are made at any point.

The Calululated Dimension expression can also work across more than one dimension so you could use:

=if(count(Stock_Level)>10,Item) or perhaps more in your case: if(Name='B' or Name='M',Item)

If that's not the solution then I'm missing what you're after I'm affraid.

All the best,

Matt - Visual Analytics Ltd

Filter Pivot Table without user making a Selection

Tue, 22 Mar 2011 11:13:35 GMT

Hi Matt

That's brilliant thanks

Steve