Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
larsenrennie
New Contributor

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

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

2 Replies
jaumecf23
Contributor III

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

you must use set analysis. Something like that:

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

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

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

Try this

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