topic Re: Comparing two Exp's in QlikView

Comparing two Exp's

roee1983 — Sun, 23 Nov 2014 20:31:10 GMT

Hi all,

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

attached is a table that show's my problem.

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 — Sun, 23 Nov 2014 20:39:46 GMT

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 — Sun, 23 Nov 2014 20:42:49 GMT

Hi,

I know

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

thanks

ali_hijazi — Sun, 23 Nov 2014 20:52:21 GMT

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

Try it please