# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for
Did you mean:
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 %) .

Second sheet tells about distinct count of employees on GRADE wise (Percentage Grade).

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
Partner

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
Master II
Author

Partner

Hi,

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

Regards,

Jagan.

Partner

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.

Partner

Hi,

PFA file for solution.

Regards,

Jagan.

Master II
Author

Hi Jagan,

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

Kindly help.

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 🙂

Partner

Hi,

Refer this file, it is working correctly.

REgards,

Jagan.

Partner

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.

Master II
Author

Dear jagan,

You are great. I bow down to your skills.

Thanks a million.