Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am new to Qlik and would appreciate any help!
I am trying to sum values within a month to get a MTD formula, except my data is not in that format. As an example for July I have this formula:
Aggr(RangeSum(Above(Sum([Total Revenue]),0,RowNo())),({$<Year=2019>}) +({<[Month.Week]="7.1","7.2","7.3","7.4","7.5"}>}))
I am hoping to have Week 1 of July, then Week 1 of July + Week 2 of July, then Week 1 of July + Week 2 of July + Week 3 of July, and so on. And then to extend formula with other months.
Would you be able to share sample data to help you better here