Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you must use set analysis. Something like that:
sum({<Location-={"DC"}>}Amount)
Contains? You mean Exclude anything with DC in it? Like ABDCSD and Washington DC?
Try this
{<Location -= {"*DC*"}>}