Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 )
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])
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
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 )
Hi Jonathan
Indeed, it works. It is also very useful to lear more about set analysis.
Thanks a lot.
Marc Van Rie
Hi Jonathan
Indeed, it works. It is also very useful to learn more about set analysis.
Thanks a lot.
Marc Van Rie