topic Re: Chart Expression in QlikView

Chart Expression

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

I need to count when status = open, AssignDate Is not null (or for this example the word Null) AND when then End date column ends in that month. See attached for example as I would like to keep the same format in my example. but below gives a better idea of what I'm looking for.

July = 52,597

June = 54,873

Customer ABC has a Start Date of 1/1/2016 and EndDate of 6/1/2016 (Could be anytime in June) The counts would look something like this...

0 1 1 1 1 1 1 0

Month 201607 201606 201605 201604 201603 201602 201601 201512 Display only six values but the counts continue

Re: Chart Expression

Anonymous — Fri, 29 Jul 2016 14:19:28 GMT

If this cannot be figured out. Is it possible to do the below?

Customer ABC has a Start Date of 1/1/2016 and EndDate of 6/1/2016 (Could be anytime in June) The counts would look something like this...

0 1 1 1 1 1 1 0

Month 201607 201606 201605 201604 201603 201602 201601 201512 Display only six values but the counts continue

Something like below (I know this is not correct)

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

Re: Chart Expression

chrisg — Fri, 29 Jul 2016 14:26:09 GMT

HI John,

just to be surewhere is your customer in the data model?

Thx

Christoph

Re: Chart Expression

Anonymous — Fri, 29 Jul 2016 14:29:31 GMT

ID would be my unqiue customer.

My dimension would be StartDate_YYYYMM

Does that answer your question?

Re: Chart Expression

Anonymous — Fri, 29 Jul 2016 14:30:58 GMT

If I need to make changed to my data model, I'm fine with doing so. I need to be able to create counts as I mentioned above.