Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariamovasheli
New Contributor III

Cumulative Area Chart

HI,

I need to make cumulative area chart. on Y axis to have cumulative percentage of sales. and also sort by companies sales Descending.

Can You Please Tell me how Can I achieve this?  

Qlik.PNG

11 Replies
jordywegmanclim
New Contributor III

Re: Cumulative Area Chart

Do you need the time as dimension on the x-axis?

Dimension 1:Put the time as a dimension

Dimension 2: Put the companies as a dimension

Measure 1: For the % on the Y axis: Sum(Volume) / Sum(TOTAL Volume).

Re: Cumulative Area Chart

This is really tough to explain, Better if you can make sample QVF file?

Num(Rangesum(Above(Sum(SALES),0,rowno(TOTAL))),'#,##0%')


Or

Rangesum(Above(Sum(SALES),0,rowno(TOTAL)))/Count(FieldName)

MVP
MVP

Re: Cumulative Area Chart

sales in descending order? But you have the x-axis to be Month... you want to reorder month to be based on sales?

mariamovasheli
New Contributor III

Re: Cumulative Area Chart

no I want descending on Y axis where I have sales. to start With the company witch has Highest Volume of sales and then who have less.this Cumulative Area To be sorted

MVP
MVP

Re: Cumulative Area Chart

Oh okay... I got you... would you be able to share a sample qvf to test this out?

mariamovasheli
New Contributor III

Re: Cumulative Area Chart

Sorry I can't

MVP
MVP

Re: Cumulative Area Chart

Mock up data to test it out?

mariamovasheli
New Contributor III

Re: Cumulative Area Chart

Yes but  I don't know how To share mock Up data

MVP
MVP

Re: Cumulative Area Chart

Put that in an Excel file and share it here

Uploading a Sample