Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression in Chart

I have the attached. I'm needing help with an expression. I would like to count id when Status = Open, AssignDate is not null. AND when the ENDDate_YYYYMM = The StartDate_YYYMM.  See excel attachment for expected results.

=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<Status = {'Open'},[Assign Date]-={''}>}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID))
//counts all open and closed of the current month

2 Replies
sunny_talwar

Is this for both sections of the expressions or one of the two?

1) Below(RangeSum(Below(Count({<Status = {'Open'},[Assign Date]-={''}>}ID), 0, NoOfRows() - RowNo() + 1)))

2) Count(ID)

Anonymous
Not applicable
Author

Both of my expression are not representing what I want displayed.The expression that I pasted above is for the bar chart only.