Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

adding months to selected range

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

2 Replies
SunilChauhan
Champion II
Champion II

post sample please

Sunil Chauhan
Not applicable
Author

Sample Data posted to Original post