Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjujeeboy
Creator
Creator

Cumulative line chart

For the below data, is it posible to create a cumulative line chart for each products

WeekProductSales
W1A7634868.2242838
W1B7651098.6170493
W1C164949644.41754
W1D33869353.592187
W1E12221260.522963
W2A4647233.9256739
W2B8337516.5448516
W2C106175855.70011
W2D23133326.334951
W2E6946136.7327755
W3A4471258.5587391
W3B4565730.3063582
W3C100130134.94571
W3D22303526.399469
W3E5802190.9364665

 

eg for W3 product A should sum all 3 weeks sales.

can it be achieved using line chart?

Labels (2)
1 Solution

Accepted Solutions
kashyap
Partner
Partner

Hi

I have attached the sample Qvf and iI have created the cumulative measure in the Back end Script

Kindly go through the script and for output go through My new sheet (2)

Hope this Helps

Thanks

View solution in original post

4 Replies
kashyap
Partner
Partner

Hi 

PFA

Thanks

sanjujeeboy
Creator
Creator
Author

Hi Kashyap,

Thanks for the solution.. it definitely worked.

One more thing. can we show Top 2 Products and show remaining as 'OTHERS' in cumulative line chart.

thanks once again

kashyap
Partner
Partner

Hi

I have attached the sample Qvf and iI have created the cumulative measure in the Back end Script

Kindly go through the script and for output go through My new sheet (2)

Hope this Helps

Thanks

View solution in original post

sanjujeeboy
Creator
Creator
Author

Thanks Kashyap!!

Your solution worked.