Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bernhard2760
Partner - Contributor III
Partner - Contributor III

Rangesum Before does not split by Date

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

bernhard2760_1-1664790418786.png

 

Labels (1)
1 Reply
Mark_Little
Luminary
Luminary

HI @bernhard2760 

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.