Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

how to calucate all date from max date to monthstart of max date

Hi all,

i want to calculate the values from 1st seotember to 8 th stepember like this for all max(date) to monthstart of max(date)

1 Reply

Re: how to calucate all date from max date to monthstart of max date

Maybe with something like this:

sum({< date = {">=$(=date(floor(monthstart(max(date))))<=$(=date(max(date)))"}>} values)

- Marcus

Community Browser