topic Re: Set analyse - select fields on values in an other field in QlikView

Set analyse - select fields on values in an other field

Wed, 03 Dec 2014 19:44:26 GMT

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

Re: Set analyse - select fields on values in an other field

JonnyPoole — Wed, 03 Dec 2014 20:19:26 GMT

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])

Re: Set analyse - select fields on values in an other field

Thu, 04 Dec 2014 16:14:48 GMT

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

Re: Set analyse - select fields on values in an other field

JonnyPoole — Thu, 04 Dec 2014 17:56:37 GMT

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 )

Re: Set analyse - select fields on values in an other field

Thu, 04 Dec 2014 18:12:30 GMT

Hi Jonathan

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

Thanks a lot.

Marc Van Rie

Re: Set analyse - select fields on values in an other field

Thu, 04 Dec 2014 18:13:04 GMT

Hi Jonathan

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

Thanks a lot.

Marc Van Rie