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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I need count in current financial year .

This is not giving me a count,

=count(If(Status_Field='Complete'

and Date1>= date(YearStart(today(0),0,4) )

and Date1< date(YearStart(today(0),1,4)), ID))

3 Replies
its_anandrjs
Champion III
Champion III

Try this way

=count(If(Match( Status_Field,'Complete' ) = 1 

and Date1>= date(YearStart(today(0),0,4) )

and Date1< date(YearStart(today(0),1,4)), ID))

Or else share any sample data.

Regards

Anand

Not applicable
Author

Thanks Anand for Reply but I resolved the issue.

Anil_Babu_Samineni

Close this thread by flag correct answer of Anand

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful