topic Re: Set analysis in QlikView

Set analysis

Tue, 02 Dec 2014 16:37:02 GMT

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

Re: Set analysis

yduval75 — Tue, 02 Dec 2014 16:41:28 GMT

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

Re: Set analysis

steeramp — Tue, 02 Dec 2014 16:42:44 GMT

Try in this way

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

Re: Set analysis

jpapador — Tue, 02 Dec 2014 16:46:33 GMT

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.

Re: Set analysis

Wed, 03 Dec 2014 07:22:57 GMT

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)

Re: Set analysis

Wed, 03 Dec 2014 07:27:19 GMT

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