Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Exclude a product line from measure equation

Hello and Happy New Year!!!

I am attempting to exclude a certain product line in a capital KPI chart.

The measure is: sum([capital])

So I attempted with this formula.

If([Business Segment]='Fruits', not Match([Product Line],
'Grapes'), [Product Line]



What I am trying to do is say, when I am selected on Fruits, I want to exclude grapes (is a product line) from the KPI capital number.

Currently, I am getting a dash with the above equation.

Thanks in advance for your help!!!!

13 Replies
Creator II
Creator II

Shoot not working on the including piece. I can keep playing with it. It is just displaying as if it is not included so far.


How about this

If(GetFieldSelection([Business Segment]) = 'Nuts', Sum({<[Product Line] = {'Apples'}, [Business Segment]>}[capital]) + Sum(capital), Sum(capital))

Creator II
Creator II

I will try this out when I get a chance. As always, thank you so much for your help Sunny.


No problem at all