Remove one value while using action in KPI

[Karthick30]

Hi,

I have created one Vizlib KPI. for count(products).. excluding location: UK.  I have a separate sheet which has all location product details. 

How to create Action to ignore location UK and move to that sheet.

Any suggestions on this

[ajaykakkar93]

hi,

set analysis can be used 
count({<location-={"UK"}>} products)

in the above code, UK will be removed/ignored/excluded for this expression & count will be populated as per other locations