Exclude field from selection

[JoseGarcia]

Hi there,

I want to exclude 'PVC_date' field from selection. 
If PVC_date filter is applied, my chart do not change.

My expression/s  (tried) seem to exclude everything else too.
Tried different expression, but do not get desired result.

PVC_date is not related to the other fields.

This is what I tried: 
Sum({1<PVC_Date=>}[Budgeted Total Cost]) 

Sum({<PVC_Date=>}[Budgeted Total Cost])

What else could I try?

Thanks a million.

Jose

[Chanty4u]

this should work. May be this filed is linked with datamodel or not? how it is defined ? 

Sum({<PVC_Date=>}[Budgeted Total Cost])

or

try this

Sum( {1} {<PVC_Date=>}[Budgeted Total Cost])

[JoseGarcia]

Tried formula. 
did not work, when I applied PVC_date field, chart updated 😞

[Chanty4u · Accepted solution]

May be this

Sum( {$<PVC_Date=>}[Budgeted Total Cost])

or just have a look on below article.

https://community.qlik.com/t5/QlikView-Documents/Ignore-all-selections-except-some-specific-fields-u...

[JoseGarcia]

Did not work. 
Thanks for the article. 🙂

I think the issue I have is that PVC_date, does not relate for Budgeted Total Cost.

Looking the other way round now.
See if I can exclude from the WBS_name from the filters election.
Filter currently has: 

Month(PVC_date) & Year(PVC_date)

How could I exclude WBS_name from such formula 😞