Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Not applicable

How to create cumulated cross tab chart with different colors for each year?

Hello QV Community,

First, I have to say that not a day goes by in my QV development that I am without you;-) This is one of the best developer community sites I have ever seen!

So my question:

I want to create a simple chart that looks like this where each year is identified by it's color and cumulates and 10% decline in sales each year...

Sample Chart.png

Currently I can use rangesum to get the accumulation, but having two problems:

1) 10% is not applied to each year, only the first,

2) I don't know how to get chart colors to work so it looks stacked for each year.

My very simple (boiled down for example) data table looks like this:

LOAD * INLINE [

    Year, Amount

    2005, "$5,358,219 "

    2006, "$6,287,505 "

    2008, "$5,284,788 "

    2009, "$5,223,151 "

    2010, "$2,540,630 "

    2011, "$3,956,128 "

    2012, "$4,177,531 "

    2013, "$4,859,928 "

    2014, "$389,112 "

];

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to create cumulated cross tab chart with different colors for each year?

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to create cumulated cross tab chart with different colors for each year?

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: How to create cumulated cross tab chart with different colors for each year?

Wow! Thank you Gysbert - this is great example and very useful to apply different colors to each year!