Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Adding 2 different sets

This should be so simple but I am drawing a blank

I have:

Product

A

B

C

D

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

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

Try this

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

+

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

israrkhan
Specialist II
Specialist II

Try Below:


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

yevgeniy
Creator
Creator

Hi,

may be try

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

,

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

*.4