topic Re: Adding together two aggr rangesum expressions in App Development

Adding together two aggr rangesum expressions

Sa_Rah — Sun, 10 Sep 2023 19:34:22 GMT

Is it possible to add together two aggr (rangesum()) expressions?

Individually the following two expressions give me what I'm expecting, but summing them means the second expression fails to calculate.

= aggr(rangesum( above(Count( distinct {<Table = {"SIP"},[Course Title] = {"ImpP*"},Date={">$(=today())"},[Attended?] = {"Attended", "Booked", "In Progress"}>}[EmNo]),0,rowno(total))),MonthYearDate )

+aggr(rangesum(above(Sum( distinct {<Table = {"SIP"}, [Course Title] = {"ImpP*"}, Date={">$(=today())"}>}CTMAP),0,rowno())),MonthYearDate)

Thanks

Sarah

Re: Adding together two aggr rangesum expressions

agigliotti — Mon, 11 Sep 2023 10:19:24 GMT

Hi @Sa_Rah ,

Maybe this:

=aggr(rangesum( above(Count( distinct {<Table = {"SIP"},[Course Title] = {"ImpP*"},Date={">$(=today())"},[Attended?] = {"Attended", "Booked", "In Progress"}>}[EmNo]),0,rowno(total))
,
above(Sum( distinct {<Table = {"SIP"}, [Course Title] = {"ImpP*"}, Date={">$(=today())"}>}CTMAP),0,rowno()))
,MonthYearDate )

I hope it can helps.

Best Regards

Re: Adding together two aggr rangesum expressions

victormarcel036 — Mon, 11 Sep 2023 10:25:47 GMT

Yes, it is possible to add together two aggr (rangesum()) expressions. However, without seeing your specific expressions and the data you are working with, it is difficult to determine why the second expression fails to calculate when you try to sum them.

Re: Adding together two aggr rangesum expressions

Sa_Rah — Mon, 11 Sep 2023 10:48:14 GMT

Thanks, this worked!

(Apologies that my account automatically marks things as solutions, the Qlik team have looked into this and apparently it relates to my organisation's firewall.)