Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Need to know Cummulative percentage of sales

Hi

i have just update cummulative sales on nozzles and i cant able to display cummulative percentage which i have used function like

nozzle sales i display cummulative nozzle by using Rangesum(above(sum(totalsalesbasedon nozzles),0,rowno(total))) and it display

everything and cummulative nozzle not in datasheet and it is on qlik inner and while i calculating  cummulative nozzle is there.

Please Do needful

what is the approached to be followed.

num(((Sum([TOTAL SALES BASED ON NOZZLES (Ltr) (S)])/sum(TOTAL [Cummulative Variation])))*10,'##.00%') but values didnt not come as expected is there any code on this and please update .

I just want to display percentage cummulative sales

stock.PNG

1 Reply
Creator II
Creator II

try this.

num((rangesum(Above(Sum([TOTAL SALES BASED ON NOZZLES (Ltr) (S)]),1,RowNo()))+sum([TOTAL SALES BASED ON NOZZLES (Ltr) (S)]))//sum(TOTAL [Cummulative Variation])))*100,'#,##0.00%')