Aggr in graph when last value is 0

lyr_com — Thu, 16 Jun 2022 06:31:47 GMT

Hi everyone 😊

I am trying to create a line graph that for each month, counts the cumulative year % of "Correct", "Incorrect" and "Partial" elements.

I've created the expressions using aggr() but when they count 0 elements of one type, the cumulative value is not shown. I understand that it won't calculate anything if there aren't values during the year (it happens with "Incorrect" elements), but it should show values if the previous months had them ("Partial" elements).

These are my expressions:

- Correct:

aggr(rangesum(Above(Count({$<Date= {"*"}, GeneralStatus = {'Correct'}, Closed = >} distinct Id),0, rowNo())), TheYearDate, TheMonthYearDate) / aggr(rangesum(Above(Count({$<AStatus = {"*"}, BStatus= {"*"}, Cstatus= {"*"}, Closed= >}distinct Id),0, rowNo())), TheYearDate, TheMonthYearDate)

- Incorrect:

aggr(rangesum(Above(Count({$<Date= {"*"}, GeneralStatus = {'Incorrect'}, Closed = >} distinct Id),0, rowNo())), TheYearDate, TheMonthYearDate) / aggr(rangesum(Above(Count({$<AStatus = {"*"}, BStatus= {"*"}, Cstatus= {"*"}, Closed= >}distinct Id),0, rowNo())), TheYearDate, TheMonthYearDate)

- Partial:

aggr(rangesum(Above(Count({$<Date= {"*"}, GeneralStatus = {'Partial'}, Closed = >} distinct Id),0, rowNo())), TheYearDate, TheMonthYearDate) / aggr(rangesum(Above(Count({$<AStatus = {"*"}, BStatus= {"*"}, Cstatus= {"*"}, Closed= >}distinct Id),0, rowNo())), TheYearDate, TheMonthYearDate)

This is what I get:

It doesn't show Jun values for "Partial" elements (it should be 15.09%). How could I get them all?

It would be great if I could also show "Incorrect" elements (0 every month). I don't have the option: "Suppress Zero-Values" selected.

Thanks in advance

topic Aggr in graph when last value is 0 in QlikView

Aggr in graph when last value is 0