topic Re: Bar Chart Accumulative Stack in QlikView

Bar Chart Accumulative Stack

dennysetiawan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expert,

I have a data like following:

The last data in the example is Feb-2017.

I want to create a Bar Chart with the expected result is like:

6 = Total Emp accum. to Feb in 2017

5 = Total Emp accum. to Feb in 2016

24 = Total Emp accum. from Jan to Dec in 2016

Can anyone help me the best practice to get the result?

Many thanks.

Re: Bar Chart Accumulative Stack

ahaahaaha — Fri, 16 Jun 2017 10:24:15 GMT

Hi,

May be like in attached file

Regards,

Andrey

Re: Bar Chart Accumulative Stack

dennysetiawan — Mon, 19 Jun 2017 03:10:26 GMT

Hi Andrey,

Thank you for your response.

How to make it dynamic? For example if my last data is Mar, so the set analysis should be Sum ({<Month={'Jan', 'Feb','Mar'}>}[# of Emp]). If my last data is Apr, it should be Sum ({<Month={'Jan', 'Feb', 'Mar','Apr'}>}[# of Emp]). etc...

Re: Bar Chart Accumulative Stack

antoniotiman — Mon, 19 Jun 2017 03:43:26 GMT

Hi Denny,

Dimension : Year

Expression ;

Sum({<Month={'>=1<=$(=Max({<Year={'$(=Max(Year))'}>} Month))'}>} NrEmp)

Sum({<Month=,Year={'$(=Max(Year)-1)'}>} NrEmp)

See Attachment.

Regards,

Antonio

Re: Bar Chart Accumulative Stack

dennysetiawan — Mon, 19 Jun 2017 06:56:46 GMT

Thank you Antonio. Looks good