topic Help with Set Analysis in QlikView

Help with Set Analysis

Tue, 27 Jul 2010 20:19:12 GMT

Hi Guys,

How do I make the following Set Analysis expression to work?

=Sum( {$< DB={'telcon'}, Part No= - {"ZI","ZP"}> } $(vOpOrdersAmountBalance)) / $(vSalesDivider1)

I need DB= 'telcon' and at the same time Part No <> from 'ZI', 'ZP'

Thanks in advance,

Aldo.

separerl — Tue, 27 Jul 2010 21:54:40 GMT

Hi Aldo !

Try something like this:

=sum( {$<DB={'telcon'}, [Part No] -={'ZI','ZP'}>} $(vOpOrdersAmountBalance)) / $(vSalesDivider1)

Note the brackets around Part No and the placement of the minus-sign

/Pär

mike_garcia — Tue, 27 Jul 2010 21:59:09 GMT

Hi,

Does the variable $(vOpOrdersAmountBalance) return a Field Name?

Mike

Wed, 28 Jul 2010 07:05:09 GMT

Yes, it returns a Field Name.

Aldo.

Wed, 28 Jul 2010 07:06:00 GMT

It works,

Thanks,

Aldo.