Applying a filter only to a specific table

[be05x5]

Hello Qlik Community, 

I tried searching around for this and it doesnt seem to be possible but I will give it a try here with a post. 

I have a Dashboard where I want to see ONLY accounts that are called trade so here is a view of that: 

So, in short, I ONLY want to see where the value of IsTradeCustomer is 1. I do NOT want to use a filter here as that carries over from sheet to sheet! 

[Lisa_P]

You could have this sheet in a new "Alternate State" that doesn't impact any other sheets. 

or

You could use expressions that specify only results for condition IsTradeCustomer=1. This is called Set Analysis and you use this inside the measure expressions in the table. If you give a formula for the measure, I can show you how to apply set analysis to it.

[be05x5]

Thank you. 

Here is a measure formula: 

Sum({<HonorStatus_Description={'Trade', 'Residental Designer','Hospitality Designer'}, Year = {"$(=max(Year))"}, inv_dt = {"<=$(=max(inv_dt))"}>}SalesAmount)

[be05x5]

Thanks however I have a formula that is already working and I think it matches your suggestion exactly: 

Sum({<HonorStatus_Description={'Trade', 'Residental Designer','Hospitality Designer'}, Year = {"$(=max(Year))"}, inv_dt = {"<=$(=max(inv_dt))"}>}SalesAmount)

I get that I would just like to ELIMINATE all accounts from this grid without using a filter? Is that possible? 

[be05x5]

I should have said filter out accounts that are not HonorStatus_Description={'Trade', 'Residental Designer','Hospitality Designer'},

[Marijn]

I don't get exactly what you want from your later comments, but I think it's this:

If you only want to see accounts IsTradeCustomer = 1, it would be this:

Sum({<
   HonorStatus_Description={'Trade', 'Residental Designer','Hospitality Designer'}, 
   Year = {"$(=max(Year))"}, 
   inv_dt = {"<=$(=max(inv_dt))"},
   IsTradeCustomer={1}                  
                                        >}SalesAmount)

If you only want to see accounts that are HonorStatus_Description={'Trade', 'Residental Designer','Hospitality Designer'} your expression should be fine.

Could you elaborate what is happening?

Keep in mind that if you use multiple set expressions with different selections, you'll have to make the appropriate selection in ALL those expressions.

[be05x5]

Sorry for the confusion. Simply put in this picture: without applying a filter I would like only accounts with 1 to be in this grid and the 0s in red NOT to show up: 

Assume I wrote a SQL query and just in it said Where IsTradeCustomer = 1 to only see those accounts! Is that doable. Does not seem like it...

[Marijn · Accepted solution]

That should work by adding

IsTradeCustomer={1} 

to you set expression.

Are there more columns with a set expression in de calculation? Because then you need to add the above to all expressions to make sure these accounts are excluded.

[be05x5]

I finally understand! Thanks.