Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
tcyw2910
Contributor II
Contributor II

KPI Count from a Date

Hi,

I was wondering if anyone knows what the formula is, if I wanted to create a KPI that starts counting from a specific date? (e.g. 02/03/2021 onwards) in that format.

 

Thanks

 

2 Replies
Chanty4u
MVP
MVP

may be this?

=Count({<Datefield={">= 02/03/2021"}>}) Distinct FIeld1)

tcyw2910
Contributor II
Contributor II
Author

I think that formula you gave me worked actually, thanks. If possible, do you also know how I should formulate it even more if I wanted to add a second Field2?