Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Set analysis

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Set analysis

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 Replies
Partner
Partner

Re: Set analysis

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

Partner
Partner

Re: Set analysis

Try in this way


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


Partner
Partner

Re: Set analysis

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.

Not applicable

Re: Set analysis

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)

Not applicable

Re: Set analysis

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