Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Comparing two Exp's

Hi all,

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

attached is a table that show's my problem.

CategorySUB TOTALSUSD
X220
X310
X330
X460
Y420
Y420
Y5100


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

3 Replies
Highlighted
Partner
Partner

Re: Comparing two Exp's

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

I can walk on water when it freezes
Highlighted
New Contributor III

Re: Comparing two Exp's

Hi,

I know 

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

thanks

Highlighted
Partner
Partner

Re: Comparing two Exp's

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

Try it please

I can walk on water when it freezes