Qlik Community

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 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
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:

Capture.JPG

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:

2.JPG

Please help me.

1 Solution

Accepted Solutions
jagan
Partner
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.

View solution in original post

9 Replies
qlikviewwizard
Master II
Master II
Author

Please help.

jagan
Partner
Partner

Hi,

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

Regards,

Jagan.

jagan
Partner
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.

jagan
Partner
Partner

Hi,

PFA file for solution.

Regards,

Jagan.

qlikviewwizard
Master II
Master II
Author

Hi Jagan,

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

Kindly help.

Capture.JPG

mario-sarkis
Creator II
Creator II

Create a Pivot or Straight Table

Your Dimension

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 🙂

jagan
Partner
Partner

Hi,

Refer this file, it is working correctly.

REgards,

Jagan.

jagan
Partner
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.

qlikviewwizard
Master II
Master II
Author

Dear jagan,

You are great. I bow down to your skills.

Thanks a million.