Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

Hi,

Refer this file, it is working correctly.

REgards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

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.