Expression

[#1]

HI

I am new to QlikView.

I am trying to write an expression that returns the number of due date that are grater or equals today's date,but the expression is returning wrong information. This is the expression

=Count(if([Closing date]>= Today(2),[Candidate FullName]))

Thanks and Regards

Priscilla

[hic]

I think your problem is in the data model. It looks like the following:

You have a synthetic key that might cause problems.

I suspect that all the candidates are found in the ZAK_RECRUTMENT, and if so you should not load the Candidat Spec table. Just remove the Load that loads this table. Or name the "Spec" from this table something else than "Spec".

HIC

[#3]

Thanks a lot

you are right the problem in in the data model.