Rangesum and Nulls

0li5a3a — Wed, 25 Nov 2020 16:16:04 GMT

Hi There,

I have the following scenario :

Dimension : Month_Year_Created

Expression1 :count({<[Resolved Within SLA] = {'Met SLA'}>}[Resolved Within SLA]) / count(total <Month_Year_Created> [Resolved Within SLA])

Expression 2: count({<[Resolved Within SLA] = {'Missed SLA'}>}[Resolved Within SLA]) / count(total <Month_Year_Created> [Resolved Within SLA])

Expresion 3: [Contractual Target]

Expresion 4: RangeSum(Above(count([Met SLA]),0,RowNo())) / RangeSum(Above(count(total <Month_Year_Created> [Resolved Within SLA]),0,RowNo()))

The problem which I have is that the Expression 4 is treating nulls like 0 and that is the reason my chart looks like below . I already

the ticket all the buttons to exclude the nulls but the chart is not right.

Could someone help me with?

Regards,

Re: Rangesum and Nulls

rubenmarin — Fri, 02 Nov 2018 09:36:36 GMT

Hi Constantin, maybe adding a condition to expression4, i.e.:

If(Month_Year_Created<Monthstart(Today()), RangeSum(Above(count([Met SLA]),0,RowNo())) / RangeSum(Above(count(total <Month_Year_Created> [Resolved Within SLA]),0,RowNo())))

Re: Rangesum and Nulls

0li5a3a — Fri, 02 Nov 2018 09:57:26 GMT

thanks, that is it:)

topic Re: Rangesum and Nulls in QlikView

Rangesum and Nulls

Re: Rangesum and Nulls

Re: Rangesum and Nulls