topic Re: Expression in Chart in QlikView

Expression in Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Expression in Chart

sunny_talwar — Wed, 27 Jul 2016 19:50:29 GMT

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)

Re: Expression in Chart

Anonymous — Thu, 28 Jul 2016 11:54:02 GMT

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