How to remove records from the Dimension used in a Pivot Table which contain specific string

[Anonymous]

Hello All

I need help in removing those which contain a specific string value in a Dimension . For example if i have a dimension as Location which is used in the pivot table , i want that those location which contain DC should be removed from the pivot table. i want to do it via expression without altering the script . Please let me know the solution as i am new to qlikview

Regards

Lokender

[jaumecf23]

you must use set analysis. Something like that:

sum({<Location-={"DC"}>}Amount)

[sunny_talwar]

Contains? You mean Exclude anything with DC in it? Like ABDCSD and Washington DC?

Try this

{<Location -= {"*DC*"}>}