Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
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.

View solution in original post

9 Replies
Highlighted
Master II
Master II

Please help.

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

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

Regards,

Jagan.

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

Hi,

PFA file for solution.

Regards,

Jagan.

Highlighted
Master II
Master II

Hi Jagan,

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

Kindly help.

Capture.JPG

Highlighted
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 🙂

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Refer this file, it is working correctly.

REgards,

Jagan.

Highlighted
MVP & Luminary
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.

View solution in original post

Highlighted
Master II
Master II

Dear jagan,

You are great. I bow down to your skills.

Thanks a million.