Rangesum Before does not split by Date

bernhard2760 · ‎2022-10-03

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

Mark_Little · ‎2022-10-11

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.