Combine the results of 2 Aggr output

[Remco]

Hello all!

I am struggling with the next, I have an output from

=

aggr(

Min(
{<
$(v_SA_Forecast_A) ,
COUNTRYCODE = {$(vFilterCountryCode)},
FLEETNAME = {$(vFilterFleetName)}
>}

EXPECTEDSALESYEAR), EXPECTEDSALESYEAR)

That returns perfectly the years. But I want to have the combined distinct values from the next set where only my filter is now Forecast_B instead of A.  So in fact, I want to combine the two outputs and ofcourse only see the distinct values. A tried a lot but can't work it out. Any suggestions?

Thanks!

[QFabian]

Hi @Remco , maybe you need to do an intersection of data sets resulting from set analysis. Check the documentation about it

*	Intersection. This binary operation returns a set consisting of the records that belong to both of the two set operands.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

example :

=

aggr(

Min(

{

<
$(v_SA_Forecast_A) ,
COUNTRYCODE = {$(vFilterCountryCode)},
FLEETNAME = {$(vFilterFleetName)}
>

*

<
$(v_SA_Forecast_B) ,
COUNTRYCODE = {$(vFilterCountryCode)},
FLEETNAME = {$(vFilterFleetName)}
>

}

EXPECTEDSALESYEAR), EXPECTEDSALESYEAR)

[Remco]

Thanks Fabian, I will check the source. For the moment the example does not work, no values returned.

[Remco · Accepted solution]

Shoot! It worked with the '+', thanks!