Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks a lot
you are right the problem in in the data model.