Rangesum Before does not split by Date

bernhard2760 — Mon, 03 Oct 2022 09:50:50 GMT

Dear Qlik Community,

I am working on a rangesum function that aggreagates values within a specified date range. The formula looks like that:

rangesum(Before(sum({<[MASTER_CAL.Date] = {">=$(=today())<=$(=date(today()+120))"}>}VU_RA_Pos.pA_Menge),0,columnno()))

Unfortunately I do not need a single value but the aggrate per Date. The above formula aggregates everything into one date column.

Any ideas?

Kind regards

Bernhard

Re: Rangesum Before does not split by Date

Mark_Little — Tue, 11 Oct 2022 06:36:31 GMT

I assuming it is because you are making a set with the date in the set expression meaning it is only apply it to the relevant date.

If you share what you are trying to achieve people may be able to suggest the best approach.