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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Maciej29
Contributor III
Contributor III

How write formula properly

Hello, 

I'm looking for support. I have question how to write formula.

I need to count [Unhold date] , but only when [Unhold date] is bigger or equal to [hold date].

 

Main is incorrect 

Count(if([Date UnHold]>=[Date Hold]),[Date UnHold])

 

Thanks in advance

 

 

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try correcting the brackets, like:

Count(if([Date UnHold]>=[Date Hold] , [Date UnHold]))

View solution in original post

2 Replies
tresesco
MVP
MVP

Try correcting the brackets, like:

Count(if([Date UnHold]>=[Date Hold] , [Date UnHold]))

Maciej29
Contributor III
Contributor III
Author

Feel embarrassed. That was easier than i thought. Thank you !