Calculate sum of an indicator between 2 dates for each month in expression

Jenny_Sa — Mon, 24 Jan 2022 08:37:17 GMT

Hello,

I have a table with :

- DATE (monthyear format : YYYYMM)

- a contract number

- FLAG : a flag (=1 or 0)

- other indicators

In my report I've build a table :

- dimension : contract number, year month

- expression : sum of flag of past 12 months

So, I need to calculate for each contract and each month the sum of past year.

Here is my expression (not working) :

Sum({<DATE={">=$(=Date(AddMonths(Max(DATE),-12),'YYYYMM'))<=$(=Date(AddMonths(Max(DATE),-1),'YYYYMM'))"}>}FLAG)=0

Your help would be highly appreciated because I'm stuck with this problem for so long.

Re: Calculate sum of an indicator between 2 dates for each month in expression

nancychandler340 — Mon, 24 Jan 2022 11:02:49 GMT

the convention that people use most often is that y depends on x. Really, though, 'x' and 'y' are just names that could be swapped out for any other symbols.

Myindigocard

topic Re: Calculate sum of an indicator between 2 dates for each month in expression in QlikView

Calculate sum of an indicator between 2 dates for each month in expression

Re: Calculate sum of an indicator between 2 dates for each month in expression