topic Re: Need cumulative counts in a bar graph (between two dates) in QlikView

Need cumulative counts in a bar graph (between two dates)

Sun, 17 Nov 2013 00:17:19 GMT

My requirement is i need to do the cumulative count between two date

Initation date to closed date

Example :

A supplier has over all 10 scar(defects) counts in different months . i need to show in the bar graph the cumulative counts in every month from the initation date to completion date ..

Need help ASAP

Re: Need cumulative counts in a bar graph (between two dates)

Sun, 17 Nov 2013 06:08:27 GMT

HI ,

You add month as Dimension and in the Expression add the sum(Defect count) and select the Full accumulation radio button in the bottom in the same Expression tab.

Regards

Yusuf

Re: Need cumulative counts in a bar graph (between two dates)

Sun, 17 Nov 2013 16:31:53 GMT

If a defect is closed then under the month it shound not show up the in the count

Re: Need cumulative counts in a bar graph (between two dates)

preminqlik — Sun, 17 Nov 2013 19:59:57 GMT

hi there,

use this expression in UI

rangesum(above(total sum([Defect count]),0,RowNo(total)))

or you can do in back end also as following

table:

Load *,

rangesum([Defect count],peek('Cumulative')) as Cumulative

resident oginal;