Aggregate with different set expressions

Franz_Lackner — Fri, 09 Apr 2021 19:43:40 GMT

there are 2000 properties in 10 different countries. Each property has a purchase price.
there are 5 appraisers. Each of them reassess some of the 20 properties.
This leads us to two tables.

1: property, country, purchase price, date of sale announcement, status of sale
2: appraiser, property, estimated price

Table one shows property, country, purchase price overruled by estimated price of selected appraiser if exists (called "current price")

IF(
ISNULL(ONLY([estimated price by appraiser]))
,ONLY($(setexpression) [purchase price])
,ONLY([estimated price by appraiser])
)

where $(setexpression) restricts to specific timeframe when sales have been announced first as well as to specific status of sale

wanted: table two should show the sum of current prices per country (formula above aggregated by country) restricted to properties that fit to $(setexpression) in general

Re: Aggregate with different set expressions

rwunderlich — Fri, 09 Apr 2021 23:47:30 GMT

Sum({set expression} Alt([estimated price by appraiser], [purchase price]))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Aggregate with different set expressions

Franz_Lackner — Sat, 10 Apr 2021 22:40:00 GMT

Thank you very much. To my shame, I didn't know about the ALT function until now.

topic Re: Aggregate with different set expressions in QlikView

Aggregate with different set expressions

Re: Aggregate with different set expressions

Re: Aggregate with different set expressions