Qlik Community

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

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

Try this:

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

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.

Thank you for your prompt reply 🙂

But its not working

MVP
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.

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

Which one is working?

MVP
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.:-)