Comparing two Exp's

[roee1983]

Hi all,

I'm trying to compare between two expressions without any luck.

attached is a table that show's my problem.

Category	SUB TOTALS	USD
X	2	20
X	3	10
X	3	30
X	4	60
Y	4	20
Y	4	20
Y	5	100

I'm trying to compare between two expressions :

1) sum({<sub totals = {3,2)>}USD) 

2)sum({<sub totals = {4}>}USD)

my problem is that I need only the categories that have totals: 2 & 3( I have 200 different categories)

I don't want to present totals with categories that don't have totals: 2 & 3(only 4)

Thanks

Roee

[ali_hijazi]

Column names are case sensitive in qlikview

In set analysis you need to put [SUB TOTALS]

you need to put brackets when column names contain spaces

[roee1983]

Hi,

I know 

my problem is that i don't want to show categories with totals that have only "4" value

thanks

[ali_hijazi]

Sum(aggr(Sum{< [sub total]={3,2}, category={"=count({<[sub total]={4}>}category)>1"}>}usd,category))

Try it please