topic Re: How do I suppress future accumulations in a line/bar chart? in QlikView

How do I suppress future accumulations in a line/bar chart?

steveniow — Tue, 08 Dec 2015 15:58:41 GMT

Hi,

I'm sure their must be an easy was of doing this but...

I am trying to compare activity that we want to happen against what we have done so far. I am accumlating the data for each days activity and using sum(activity) to calulate the results.

Unfortunately - by accumlating I am finding data that is now showing into the future. I have tried every thing I can thing of but cannot get rid of the future activity whilst maintaining the future forecast.

it currently looks like this... and I would like to get rid of all the blue bars from the point at which it flat lines.

Re: How do I suppress future accumulations in a line/bar chart?

sunny_talwar — Tue, 08 Dec 2015 17:42:41 GMT

May be restrict the sum(activity) using set analysis to show only data up till today.

Re: How do I suppress future accumulations in a line/bar chart?

Tue, 08 Dec 2015 17:59:22 GMT

Try to use set analysis combine with rangesum and show AMT to month you need.

if (sum ( {$<[Year] = {$(#=Only(vYY))}, [Month] = {"<=$(#=Only(vMM))"}>} [AMT]),

rangesum ( sum ( {$<[Year] = {$(#=Only(vYY))}, [Month] = {"<=$(#=Only(vMM))"}>} [AMT]),

above("Actual")

))