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

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

Fri, 14 Aug 2015 05:41:17 GMT

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 🙂

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

sunny_talwar — Fri, 14 Aug 2015 05:47:18 GMT

Try this:

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

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

settu_periasamy — Fri, 14 Aug 2015 05:47:40 GMT

Hi,

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

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

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

Fri, 14 Aug 2015 06:00:32 GMT

Thank you for your prompt reply 🙂

But its not working

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

jonathandienst — Fri, 14 Aug 2015 06:02:39 GMT

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)

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

Fri, 14 Aug 2015 06:04:03 GMT

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.

sunny_talwar — Fri, 14 Aug 2015 06:04:46 GMT

Which one is working?

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

jonathandienst — Fri, 14 Aug 2015 06:06:21 GMT

And you would like to guess which one, perhaps?

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

Fri, 14 Aug 2015 06:51:23 GMT

First one is working.. but no change in percentage

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

Fri, 14 Aug 2015 06:54:34 GMT

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

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

sunny_talwar — Fri, 14 Aug 2015 06:58:04 GMT

Then you need this one I believe:

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

and I believe this one will also work:

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

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

Anonymous — Fri, 14 Aug 2015 07:04:24 GMT

Hi Anees,

please try below:

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

Regards

Neetha

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

Fri, 14 Aug 2015 07:22:30 GMT

Nop, That too didnt worked.

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

Anonymous — Fri, 14 Aug 2015 07:23:47 GMT

please can you elaborate on your requirement and post sample data if possible.

Regards

Neetha

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

jonathandienst — Fri, 14 Aug 2015 08:16:27 GMT

I think you should post a sample. Some attempt by yourself at a diagnosis or specifics of how they did not work would also help.

Something else to try:

=Sum({1 - <percentage = P(percentage), amount = P(amount)>} amount)

=Sum({1 - <percentage = P(percentage), amount = P(amount)>} percentage)

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

Anonymous — Fri, 14 Aug 2015 09:02:56 GMT

hi anees,

may be try:

=Sum({<percentage -= percentage, amount -= amount>} amount)

=Sum({<percentage -= percentage, amount -= amount>} percentage)

Regards

Neetha