topic Cumulative value in the graph in QlikView https://community.qlik.com/t5/QlikView/Cumulative-value-in-the-graph/m-p/1158043#M377615 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have in my Qlikviewbericht data from an Excel list.</P><P>Example:</P><P></P><P>Year / Month: Jan16 Feb16 Mar16 Apr16</P><P>Default: 10 12 12 15</P><P>Actual value 5 13 11 19</P><P>coloring; red green red green</P><P>Color Cumulative: red red red red</P><P>I Face the as graph with lines (default) and bars (Is) represents.</P><P>If the actual values ​​(bars), I have a query regarding the coloring deposited with background color.</P><P>If the actual value is higher than the default should the bar be green, otherwise red.</P><P></P><P>Now I have my formulas [sum (actual value)] and [sum (default)] copied again and called these "cumulative" and the option with the graphics "Accumulation: Full accumulation" is selected.</P><P></P><P>The values ​​are displayed correctly, but my color scheme of the background is not working so. Even if I have the name of the formulas "actual value cumulated" behind lege instead the formulas Farbgebgung is always "actual values" is displayed and not the accumulated values ​​?!</P><P></P><P>Is there a way to change that?</P></BODY></HTML> Thu, 09 Jun 2016 08:05:43 GMT alexander__ 2016-06-09T08:05:43Z Cumulative value in the graph https://community.qlik.com/t5/QlikView/Cumulative-value-in-the-graph/m-p/1158043#M377615 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have in my Qlikviewbericht data from an Excel list.</P><P>Example:</P><P></P><P>Year / Month: Jan16 Feb16 Mar16 Apr16</P><P>Default: 10 12 12 15</P><P>Actual value 5 13 11 19</P><P>coloring; red green red green</P><P>Color Cumulative: red red red red</P><P>I Face the as graph with lines (default) and bars (Is) represents.</P><P>If the actual values ​​(bars), I have a query regarding the coloring deposited with background color.</P><P>If the actual value is higher than the default should the bar be green, otherwise red.</P><P></P><P>Now I have my formulas [sum (actual value)] and [sum (default)] copied again and called these "cumulative" and the option with the graphics "Accumulation: Full accumulation" is selected.</P><P></P><P>The values ​​are displayed correctly, but my color scheme of the background is not working so. Even if I have the name of the formulas "actual value cumulated" behind lege instead the formulas Farbgebgung is always "actual values" is displayed and not the accumulated values ​​?!</P><P></P><P>Is there a way to change that?</P></BODY></HTML> Thu, 09 Jun 2016 08:05:43 GMT https://community.qlik.com/t5/QlikView/Cumulative-value-in-the-graph/m-p/1158043#M377615 alexander__ 2016-06-09T08:05:43Z