https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1670812#M50702 <P><EM>Thanks Kashyap!!</EM></P><P><EM>Your solution worked.</EM></P> Thu, 30 Jan 2020 10:21:55 GMT sanjujeeboy 2020-01-30T10:21:55Z https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1667627#M50354 <P>For the below data, is it posible to create a cumulative line chart for each products</P><TABLE><TBODY><TR><TD>Week</TD><TD>Product</TD><TD>Sales</TD></TR><TR><TD>W1</TD><TD>A</TD><TD>7634868.2242838</TD></TR><TR><TD>W1</TD><TD>B</TD><TD>7651098.6170493</TD></TR><TR><TD>W1</TD><TD>C</TD><TD>164949644.41754</TD></TR><TR><TD>W1</TD><TD>D</TD><TD>33869353.592187</TD></TR><TR><TD>W1</TD><TD>E</TD><TD>12221260.522963</TD></TR><TR><TD>W2</TD><TD>A</TD><TD>4647233.9256739</TD></TR><TR><TD>W2</TD><TD>B</TD><TD>8337516.5448516</TD></TR><TR><TD>W2</TD><TD>C</TD><TD>106175855.70011</TD></TR><TR><TD>W2</TD><TD>D</TD><TD>23133326.334951</TD></TR><TR><TD>W2</TD><TD>E</TD><TD>6946136.7327755</TD></TR><TR><TD>W3</TD><TD>A</TD><TD>4471258.5587391</TD></TR><TR><TD>W3</TD><TD>B</TD><TD>4565730.3063582</TD></TR><TR><TD>W3</TD><TD>C</TD><TD>100130134.94571</TD></TR><TR><TD>W3</TD><TD>D</TD><TD>22303526.399469</TD></TR><TR><TD>W3</TD><TD>E</TD><TD>5802190.9364665</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>eg for W3 product A should sum all 3 weeks sales.</P><P>can it be achieved using line chart?</P> Sat, 16 Nov 2024 19:16:11 GMT https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1667627#M50354 sanjujeeboy 2024-11-16T19:16:11Z https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1667664#M50361 <P>Hi&nbsp;</P><P>PFA<BR /><BR /></P><P>Thanks</P> Tue, 21 Jan 2020 10:59:28 GMT https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1667664#M50361 Kashyap_R 2020-01-21T10:59:28Z https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1668559#M50470 <P>Hi Kashyap,</P><P>Thanks for the solution.. it definitely worked.</P><P>One more thing. can we show Top 2 Products and show remaining as 'OTHERS' in cumulative line chart.</P><P>thanks once again</P> Thu, 23 Jan 2020 15:28:38 GMT https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1668559#M50470 sanjujeeboy 2020-01-23T15:28:38Z https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1668758#M50498 <P>Hi</P><P>I have attached the sample Qvf and iI have created the cumulative measure in the Back end Script</P><P>Kindly go through the script and for output go through&nbsp;<STRONG>My new sheet (2)</STRONG></P><P>Hope this Helps</P><P>Thanks</P> Fri, 24 Jan 2020 09:03:30 GMT https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1668758#M50498 Kashyap_R 2020-01-24T09:03:30Z https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1670812#M50702 <P><EM>Thanks Kashyap!!</EM></P><P><EM>Your solution worked.</EM></P> Thu, 30 Jan 2020 10:21:55 GMT https://community.qlik.com/t5/App-Development/Cumulative-line-chart/m-p/1670812#M50702 sanjujeeboy 2020-01-30T10:21:55Z