topic Re: Full accumulation - Stop bar after current month in QlikView

Full accumulation - Stop bar after current month

l_denivelle — Tue, 10 Apr 2018 09:40:01 GMT

I have a chart presenting an accumulation of amount on Year N and N-1.

But for the current year I don't want my accumulation to appear after the last month of data.

Knowing that my data are stopped at March 31st 2018.

Any idea ?

regards

olivierrobin — Tue, 10 Apr 2018 09:43:05 GMT

hello

maybe specifying a limit on current month in a set analysis

sommenting like : year={'Current Year'],month={'<=current month'} ?

l_denivelle — Tue, 10 Apr 2018 09:54:17 GMT

It works but if I'm displaying only the current year.

By showing last year, all the months are displayed so I think that's why it continues the accumulation on the following months.

olivierrobin — Tue, 10 Apr 2018 10:00:29 GMT

and if you try something like this

sum( ... if(month<=current month),value,0) ?

l_denivelle — Thu, 12 Apr 2018 13:44:49 GMT

No it didn't work 😞

Maybe it's not possible if there are other values on the chart.. because without N-1 it works :

but with N-1 :

mt03272mt — Fri, 13 Apr 2018 08:46:22 GMT

Hey Denivelle,

Recently I had the same problem...

Only one working solution I came up with was playing with colors in the chart.

So you will want to make conditional coloring for current year expression ... make it white and transparent if month is > then current month.

Hope this partial solution helps

anders_thorngaa — Fri, 13 Apr 2018 08:56:08 GMT

Hi Laure,

Pls. see the attached files. Also note, that I have defined 2 variables which are used in the set-formula.

Rgds. Anders

l_denivelle — Fri, 13 Apr 2018 12:42:59 GMT

Hi Anders

Yes ! it works !

Thank you

l_denivelle — Mon, 23 Apr 2018 08:39:37 GMT

It's working but I can't find a way to remove the expression values on the chart for the following months :