Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Arjunarao
Honored Contributor 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
MVP & Luminary
MVP & Luminary

Re: Calculate cummulative percentage of the SAL

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
Arjunarao
Honored Contributor II

Re: Calculate cummulative percentage of the SAL

Please help.

MVP & Luminary
MVP & Luminary

Re: Calculate cummulative percentage of the SAL

Hi,

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

Regards,

Jagan.

MVP & Luminary
MVP & Luminary

Re: Calculate cummulative percentage of the SAL

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.

MVP & Luminary
MVP & Luminary

Re: Calculate cummulative percentage of the SAL

Hi,

PFA file for solution.

Regards,

Jagan.

Arjunarao
Honored Contributor II

Re: Calculate cummulative percentage of the SAL

Hi Jagan,

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

Kindly help.

Capture.JPG

mario-sarkis
Contributor II

Re: Calculate cummulative percentage of the SAL

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 🙂

MVP & Luminary
MVP & Luminary

Re: Calculate cummulative percentage of the SAL

Hi,

Refer this file, it is working correctly.

REgards,

Jagan.

MVP & Luminary
MVP & Luminary

Re: Calculate cummulative percentage of the SAL

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.

Arjunarao
Honored Contributor II

Re: Calculate cummulative percentage of the SAL

Dear jagan,

You are great. I bow down to your skills.

Thanks a million.