Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
I know
my problem is that i don't want to show categories with totals that have only "4" value
thanks
Sum(aggr(Sum{< [sub total]={3,2}, category={"=count({<[sub total]={4}>}category)>1"}>}usd,category))
Try it please