How do I remove specific field name from appearing in Qlik Sense chart?

[scheibercamo]

For example, if I have the following, for which I want to display a total sum for unique managed segments based on their counts.

Mgd Seg 05	Count
Markets	780
Purchases	89
Insurance	9098
Markets	9865
Bonds	522
Equities	45
Markets	63
Bonds	554

When I make a bar chart, I do NOT want Markets to show..but I don't want to delete the metrics from the data. How can I do this?

Thanks for the help in advance

Ricky

[aarkay29]

May be something like this:

Count({<[Mgd Seg 05]-={"Markets"}>}Field)

[scheibercamo]

doesn't seem to work.

what do insert for field?

[aarkay29 · Accepted solution]

Field is nothing but field name that has value of managed subjects i.e. COUNT i believe from your example.

if you want the sum of the managed subjects to show except for Markets

Use this as expression Sum({<[Mgd Seg 05]-={"Markets"}}Count) and [Mgd Seg 05] as dimension.

If this is not what you wanted, please give a little more detail !!