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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
daisy1438
Contributor III
Contributor III

Help on below set expression?

Hi

I have fields targetdate ,opendate,issue ID and status.

I need set expression for below requirement.

count the issue id when targetdate >= opendate and status is open.

I am writing the below expression but it is not working properly.

Count({<[ Target date]>= [opendate ],Status={'Open'}>}distinct Issue ID)

  Thanks.

10 Replies
daisy1438
Contributor III
Contributor III
Author

ok thanks Ail. Its working for me also.