Set analysis

[#1]

Hello

I have a problem

In my expression, I only want to count Besteknummer (=Tender number) where the

date in the field [Datum 7: Finale goedkeuring] is equal to the date in the field [Datum 1: Lancering Workflow]"

=Count(DISTINCT{<[Datum 7: Finale goedkeuring]={"=[Datum 1: Lancering Workflow]"}>}Besteknummer)

It doesn't work.

Can somebody help me ?

Thanks in adance

Marc

[yduval75]

=Count(DISTINCT{<[Datum 7: Finale goedkeuring]={"=$(=Only([Datum 1: Lancering Workflow]))"}>}Besteknummer)

[steeramp]

Try in this way

=Count(DISTINCT{<[Datum 7: Finale goedkeuring]={"$(=[Datum 1: Lancering Workflow])"}>}Besteknummer)

[jpapador · Accepted solution]

Try it with indirect set analysis:

Count(DISTINCT{<[Datum 7: Finale goedkeuring]=P([Datum 1: Lancering Workflow])>}Besteknummer)

The Datum 7 field with equal the possible values in the Datum 1 field.

[#5]

Hi

Your solution

(Count(DISTINCT{<[Datum 7: Finale goedkeuring]=P([Datum 1: Lancering Workflow])>}Besteknummer) DISTINCT{<[Datum 7: Finale goedkeuring]=P([Datum 1: Lancering Workflow])>}Besteknummer)

[#6]

Hi

The solution by jpapador<http://community.qlik.com/people/jpapador?et=watches.email.thread> is

Count(DISTINCT{<[Datum 7: Finale goedkeuring]=P()>}Besteknummer)

Thank you

Marc