Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

rangesum cumulative value not as expected

Hi All

can anyone explain why my rangesum isn't returning the correct cumulative figure in my Delivered chart while it is in my RDD and FDD chart. The date dimension is in the same order as I force the order with a load statement.

Am I missing something straightforward?

Thanks in advance

Tracy

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: rangesum cumulative value not as expected

I think you had a closing parenthesis at incorrect location... Try this:

RangeSum(Above(Count({<PassFail={'Fail'}, Type={'Delivered'}>} COVLOOKUP), 0, RowNo()))

Instead of this

RangeSum(Above(Count({<PassFail={'Fail'}, Type={'Delivered'}>} COVLOOKUP)), 0, RowNo())

View solution in original post

7 Replies
Highlighted

Re: rangesum cumulative value not as expected

I think you had a closing parenthesis at incorrect location... Try this:

RangeSum(Above(Count({<PassFail={'Fail'}, Type={'Delivered'}>} COVLOOKUP), 0, RowNo()))

Instead of this

RangeSum(Above(Count({<PassFail={'Fail'}, Type={'Delivered'}>} COVLOOKUP)), 0, RowNo())

View solution in original post

Highlighted
Contributor

Re: rangesum cumulative value not as expected

Thanks again Sunny

I think the fact that I have been working for 12 hours straight through is having an impact!!

Tracy

Highlighted

Re: rangesum cumulative value not as expected

Hahahaha sure looks like that

Highlighted
Contributor

Re: rangesum cumulative value not as expected

can I ask your advice on how you would go about combining the 2 bar charts together? I think I will leave until the morning but any pointers would be greatly received!

The client does it manually in excel at the moment. it looks like this in excel

Capture.PNG

Highlighted

Re: rangesum cumulative value not as expected

Try this expression may be (without full accumulation)

Pick(Dim,

Aggr(RangeSum(Above(if(Source='Current',  count(COVLOOKUP),

above((sum(aggr(sum(above(count({<Week_Combined=>}COVLOOKUP), 0)),Week_Combined, OverdueAge ))))

- count(COVLOOKUP)

), 0, RowNo())), OverdueAge, Week_Combined),

Aggr(NODISTINCT If(WeekOverDue = Week_Combined,

RangeSum(above(TOTAL count({<PassFail={'Fail'}, Type={'Delivered'}>}COVLOOKUP), 0, rowno(TOTAL)))

-

RangeSum(above(TOTAL count({<PassFail={'Fail'}, Type={'Failed'}>}COVLOOKUP), 0, rowno(TOTAL)))), WeekOverDue, Week_Combined))


Capture.PNG

Highlighted
Contributor

Re: rangesum cumulative value not as expected

Sunny, thank you for this.

This is perfect. I have not done anything like this before and its really useful to know this is possible. I doubt I would have got to this solution quickly on my own.

I have given you all the credit with my Client

Tracy

Highlighted

Re: rangesum cumulative value not as expected

Hahahaha I am awesome I was able to help I would just you to take some time to mark helpful responses, if you think it will be helpful for others to see.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny