adding months to selected range

Fri, 12 Dec 2014 10:54:10 GMT

HI,

I have got a scenario where in when I select yearmonth range for example 201301 to 201306

then I need to sum(key) where in

resultant should be like for

201301 -> postyearmonth should consider from 201301 to next 5months i.e 201305

I have written like sum({<postyearmnt={">=$(=yearmonth) <=$(=addmonths(yearmonth,5))"}>}Key)

like this for 201302 also and go on

values are correct when I selected only single yearmonth then I am getting correct values

but when I select multiple yearmonths then postig yearmnt starting from repective yearmonth only but postingyearmnt end is not changing for 201302 ,201203 ,201304 ,201305 ,201306 .

it is fixed to 201305 .

please suggest me solution for this. ASAP

Thanks in advance.

$@M

Re: adding months to selected range

SunilChauhan — Fri, 12 Dec 2014 10:56:58 GMT

post sample please

Re: adding months to selected range

Sat, 13 Dec 2014 06:51:51 GMT

Sample Data posted to Original post

topic Re: adding months to selected range in QlikView

adding months to selected range

Re: adding months to selected range

Re: adding months to selected range