Set analyse - select fields on values in an other field

[#1]

Hello

I have a straigt table in which  I want only to show the records where there is an [Etappe (tekst)]
‘Goedkeuring bestek’ and ‘Gunning van de opdracht’ for each Besteknummer.

Or only show Besteknummer where there is an [Etappe (tekst)] ‘Goedkeuring bestek’ and ‘Gunning van de opdracht’.

My current expression is

=Count({<[Etappe (tekst)]={'Goedkeuring bestek','Gunning van de opdracht'}>}Besteknummer) 

Thanks in advance

Marc Van Rie

[JonnyPoole]

Use the '*'  intersection clause in SET ANALYSIS to find the records that have both.

This for example returns a set of dimensional values where the values have record(s) from Region=Asia  AND Region=Europe

count( {$<Region={'Asia'}>*<Region={'Europe'}>} DISTINCT [Transaction ID])

[#3]

Hi Jonathan

Thank you for the information.

I have modified the expression in

=count({$<[Etappe (tekst)]={'Goedkeuring bestek'}>*<[Etappe (tekst)]={'Gunning van de opdracht'}>}Besteknummer)

But I have no records.

Thanks in adavance.

Marc

[JonnyPoole · Accepted solution]

Its actually ends up being more complicated because we need to intersect the list of Besteknummers that come back from both Etappe filters:

count( {$<Besteknummer=p({<[Etappe (tekst)]={'Gunning van de opdracht'}>} )>   *  $<Besteknummer=p({$<[Etappe (tekst)]={'Goedkeuring bestek'}>})>} Besteknummer )

[#5]

Hi Jonathan

Indeed, it works. It is also very useful to lear more about set analysis.

Thanks a lot.

Marc Van Rie

[#6]

Hi Jonathan

Indeed, it works. It is also very useful to learn more about set analysis.

Thanks a lot.

Marc Van Rie