# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT Not applicable

## Using exclusion logic for two different fields in a single expression.

I have got two expressions:

1.sum({<percentage=e(percentage)>}amount)

2.sum({<amount=e(amount)>}amount)

actually for excluding  the selection of percentage and amount selection.

Can I include it in a single expression.?

Just like :- sum({<percentage=e(percentage) or amount=e(amount)>}amount)

But i think 'or' function wont work in this case, Shed some light on this 🙂

15 Replies MVP

## Re: Using exclusion logic for two different fields in a single expression.

Try this:

=Sum({<percentage=e(percentage)>+<amount=e(amount)>} amount) MVP

## Re: Using exclusion logic for two different fields in a single expression.

Hi,

You can use '+' symbol for or expression. Like

=sum({<percentage=e(percentage)> + <amount=e(amount)>}amount) Not applicable

## Re: Using exclusion logic for two different fields in a single expression.

But its not working  MVP

## Re: Using exclusion logic for two different fields in a single expression.

Are you looking for a union (excluded by either percent or amount, or both)

=Sum({<percentage = e(percentage)> + <amount = e(amount)>} amount)

or are you looking for an intersection (only excluded by both percent and amount)?

=Sum({<percentage = e(percentage)> * <amount = e(amount)>} amount)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein Not applicable

## Re: Using exclusion logic for two different fields in a single expression.

I have got two expressions.

=sum({<percentage=e(percentage)> + <amount=e(amount)>}amount)

=sum({<percentage=e(percentage)> + <amount=e(amount)>}percentage)

but only one expression is working.  MVP

## Re: Using exclusion logic for two different fields in a single expression.

Which one is working? MVP

## Re: Using exclusion logic for two different fields in a single expression.

And you would like to guess which one, perhaps?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein Not applicable

## Re: Using exclusion logic for two different fields in a single expression.

First one is working.. but no change in percentage Not applicable

## Re: Using exclusion logic for two different fields in a single expression.

If I am selecting value 10 for percentage and value 200 for amount, then it should exclude percentage 10 and amount 200 values from that table and should show the rest of the values.

That exactly what I want.:-)