topic Re: Re: consecutive months addition in QlikView

consecutive months addition

Fri, 20 Nov 2020 18:02:30 GMT

Hi ,

I have only year and month fields. and on selection of year and month, it should give me the addition of months since January.

For ex, on selecting 2014 March, i want sum of January2014 + february 2014 and march 2014 value.

Thanks

anbu1984 — Fri, 19 Sep 2014 13:16:00 GMT

Do you mean sum of days or count of months from Jan to Mar?

Fri, 19 Sep 2014 13:22:01 GMT

Use rangesum() function may be u vl get correct output

Fri, 19 Sep 2014 13:26:59 GMT

Hi ,

I have only year and month fields. and on selection of year and month, it should give me the addition of months since January.

For ex, on selecting 2014 March, i want sum of January2014 + february 2014 and march 2014 value.

Thanks

anbu1984 — Fri, 19 Sep 2014 14:01:11 GMT

Check this