# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Master II

## Calculate cummulative percentage of the SAL

Hi All,

There are two sheets in the application.

First sheet tells about SAL,COMM,COMM/SAL,Cummulative SAL,Cummulative COMM,Cummulative COMM/Cummulative SAL (Cummulative %) .

Sheet1 selection:

Cumm % is 18.8% when I select 2015,Q2. But in sheet2 it is showing 2 records GRADE 10%-20% and 20%-30%. These two are Q1 and Q2 values. I want to show 10%-20% as Cumm % is 18.8%.

Sheet2 selection:

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary

Hi,

Please find attached file for solution, I did this only for 0-10% and 10-20%, you can implement the same for remaining.

Regards,

Jagan.

9 Replies
Highlighted
Master II

Highlighted
MVP & Luminary

Hi,

For this you should calculate in the Front end for this chart.

Regards,

Jagan.

Highlighted
MVP & Luminary

Try this by creating a synthetic dimension using ValueList() and calculate the same in the front end.

Formatted Report Type Chart using Valuelist

Synthetic Dimensions - ValueList() (Example)

Regards,

jagan.

Highlighted
MVP & Luminary

Hi,

PFA file for solution.

Regards,

Jagan.

Highlighted
Master II

Hi Jagan,

For SMITH, Q2 - No of Emps value is showing zero values.

Kindly help.

Highlighted
Creator II

Create a Pivot or Straight Table

Expression

1)

SUM([No Clts])

2) Cumm.

RangeSum(Above(Sum(Com CUmm),0,RowNo()))/SUM(TOTALCom CUmm)

Don't forget to change the 2nd expression to % Format using Number tab 🙂

Highlighted
MVP & Luminary

Hi,

Refer this file, it is working correctly.

REgards,

Jagan.

Highlighted
MVP & Luminary

Hi,

Please find attached file for solution, I did this only for 0-10% and 10-20%, you can implement the same for remaining.

Regards,

Jagan.

Highlighted
Master II

Dear jagan,

You are great. I bow down to your skills.

Thanks a million.