Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
anothergreg
New Contributor III

Re: Date set analysis showing incorrect count

Added sample

anothergreg
New Contributor III

Re: Date set analysis showing incorrect count

Added sample

Re: Date set analysis showing incorrect count

Check this

=Num(Count(TOTAL {<[EVAL_DT]={"$(=Date($(vMaxEval),'DDMMMYYYY'))"}>}CLM_NBR),'###0')

Capture.PNG

anothergreg
New Contributor III

Re: Date set analysis showing incorrect count

This looks like it works at first, but I tried using this and included the full set {1} and my filters are changing the value.  It should remain constant regardless of filters - it's an overall contents page and it should be a constant value always.

Re: Date set analysis showing incorrect count

Try this

=Num(Count(TOTAL {1<[EVAL_DT]={"$(=Date($(vMaxEval),'DDMMMYYYY'))"}>}CLM_NBR),'###0')

Also, update your variable vMaxEval to this

=max({1} EVAL_DT)

anothergreg
New Contributor III

Re: Date set analysis showing incorrect count

THANK YOU!