topic Re: Years Total in MonthYear Chart in QlikView

Years Total in MonthYear Chart

Fri, 11 Sep 2015 20:04:23 GMT

Hello,

I was wondering if anyone can help me figure this out.

Im currently displaying the amount of time of requsition forms by the monthyear, with data from 2013 to 2015.

I was wondering how can i make a bar graph, that would have the first 2 bars the TOTAL time from 2013 and the TOTAL time from 2014, followed by the monthyears of 2015, till the date, and ended by a Current Total of 2015.

Am i being clear?

Is there any easy way of doing this?

thanks for your time

Re: Years Total in MonthYear Chart

MK_QSL — Fri, 11 Sep 2015 20:13:29 GMT

Create KPI in script by grouping your desired monthyears..

Re: Years Total in MonthYear Chart

MarcoWedel — Fri, 11 Sep 2015 23:44:17 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

Re: Years Total in MonthYear Chart

Fri, 18 Sep 2015 18:41:44 GMT

im sorry but i dont understand how u create the last column of Total 2015?

Is it on the expression? or where u edit that?

thanks

Re: Years Total in MonthYear Chart

MarcoWedel — Fri, 18 Sep 2015 21:48:54 GMT

it's a separate transparent chart on top of the other chart.

regards

Marco

Re: Years Total in MonthYear Chart

Mon, 21 Sep 2015 16:14:49 GMT

How to do this, if its not just one graph, but around 5 that minimize each other, how can i make the correct transparent graph to show?

thanks alot for the help