topic Re: Adding 2 different sets in QlikView

Adding 2 different sets

zagzebski — Mon, 28 Oct 2013 18:43:26 GMT

This should be so simple but I am drawing a blank

I have:

Product

Region

North

South

East

West

I want to add set analysis like below but it doesn't seem to work:

=sum(
{<[Product]={'A','B'}>}
Sales)

sum(
{<[Region]={'North','South'}>}
Sales)*.4

CELAMBARASAN — Mon, 28 Oct 2013 18:48:12 GMT

Hi,

Try this

(sum(
{<[Product]={'A','B'}>}
Sales)

sum(
{<[Region]={'North','South'}>}
Sales)) * .4

israrkhan — Mon, 28 Oct 2013 18:54:49 GMT

Try Below:

=num((sum({<[Product]={'A','B'}>}Sales)+sum( {<Region={'North','South'}>}Sales))*.4,'###0.00')

yevgeniy — Tue, 29 Oct 2013 09:54:21 GMT

Hi,

may be try

rangesum(sum(
{<[Product]={'A','B'}>}
Sales)

sum(
{<[Region]={'North','South'}>}
Sales))

*.4