topic Re: Set analysis in QlikView

Set analysis

mario-sarkis — Tue, 30 Jun 2015 07:43:17 GMT

hey All

my question is i have this fields

Currency amount

001 1000

002 1500

003 1500

004 2000

005 1000

006 500

i need to do the summation of amount with condition the currency has to be diffrent then 001 and 002

Sum({<Currency <>{'001','002'}>}Amount) this isn't work

Thank you hope you can help

Re: Set analysis

Tue, 30 Jun 2015 07:56:44 GMT

Hi ,

try this

Sum({<Currency -={'001','002'}>}Amount)

Re: Set analysis

prashantbaste — Tue, 30 Jun 2015 08:04:46 GMT

Hi Mario

You can try sum( {$<Currency= E({1<Currency={'001','002'}>})>} Amount)

Let me know if this is helpful for you?

Regards,

Prashant P Baste

Re: Set analysis

Anonymous — Tue, 30 Jun 2015 08:06:29 GMT

Hi,

You can even use um({<Currency={'*'}-{'001','002'}>}Amount)

Re: Set analysis

krishna20 — Tue, 30 Jun 2015 08:07:42 GMT

Hi,

Try like

Sum({<Currency<>{'001'}>}Amount) + Sum({<Currency<>{'002'}>}Amount)

Re: Set analysis

Anonymous — Tue, 30 Jun 2015 08:17:41 GMT

Hi,

Follow the procedure:

1. First select expression as sum(amount) and create a pie chart.

2. Select 001 and 002 currency and add a bookmark with name 'book'.

3. Now, go to properties and change expression with following expression:

=sum({1-Book}(amount))

That's it.

You will get a pie chart which will be showing currency except 001 and 002.

Have a look over following example.

Re: Set analysis

vcanale — Tue, 30 Jun 2015 08:22:11 GMT

Hi,
try this:

sum({$<Currency={'*'}-{'001','002'}>}Amount)

Re: Set analysis

sasiparupudi1 — Tue, 30 Jun 2015 08:36:32 GMT

sum(amount)-sum({<Currency={'001','002'}>}amount)

Re: Set analysis

Anonymous — Tue, 30 Jun 2015 08:38:14 GMT

Hi,

Follow the procedure:

1. First select expression as sum(amount) and create a pie chart.

2. Select 001 and 002 currency and add a bookmark with name 'book'.

3. Now, go to properties and change expression with following expression:

=sum({1-Book}(amount))

That's it.

You will get a pie chart which will be showing currency except 001 and 002.

Re: Set analysis

Gabriel — Tue, 30 Jun 2015 09:02:06 GMT

Hi,

Try using this Set Analysis. What you wanted to say in your expression is give me the sum of Amount , Where currency ={*} all currency but remove Where currency = 001,002 that's where you use - {001,002}

Here is the solutions

({$<Currency = {*} - {001,002}>} amount)

Let me know if it work

Re: Set analysis

sasiparupudi1 — Wed, 01 Jul 2015 09:09:17 GMT

Are you still having an issue with your requirement, if yes, please share a qvw so that we can help you

Sasi