Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

count Datefield1 -= Datefield2 DISTINCT on Field3

Good Day Community we would like to do the following:

count Datefield1 -= Datefield2 DISTINCT on Field3

But we seem to be struggling with the correct syntax.

We want to count distinct Field3 where DateField1 is not equal to DateField2.

Your most urgent assistance is appreciated.

1 Solution

Accepted Solutions

Re: count Datefield1 -= Datefield2 DISTINCT on Field3

May be this:

Count(DISTINCT {<Field3 = {"=DateField1 <> DateField2"}>} Field3)

5 Replies

Re: count Datefield1 -= Datefield2 DISTINCT on Field3

May be this:

Count(DISTINCT {<Field3 = {"=DateField1 <> DateField2"}>} Field3)

Not applicable

Re: count Datefield1 -= Datefield2 DISTINCT on Field3

Thank you for your quick response, just to clarify in our example:

  • Field3 is a unique identity number for example for a person's id number.
  • Datefield1 is a date that the person registered.
  • Datefield2 is a date that the person resigned.

So basically if the two dates aren't equal count distinctly Field3.

Would your above example still apply?

Regards,

Heinrich

Re: count Datefield1 -= Datefield2 DISTINCT on Field3

So just to make sure I understand. Each persion's id will only have a single Datefield1 and Datefield2 or can they have multiple values for Datefield1 and Datefield2?

Not applicable

Re: count Datefield1 -= Datefield2 DISTINCT on Field3

It worked! Thank you so much!

Re: count Datefield1 -= Datefield2 DISTINCT on Field3

Awesome

Community Browser