Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

rdsuperlike
New Contributor III

conditional formatting with percentage values and percentile colors

Hi,

I want to create a table in qlikview as below but for each date (row) I want the cell to show the percentage value.  ex:for 5/12/2014 level 1 should show 12/12+50+75 = 12/137 = 8.75%. I could do this part.

But i couldnt do the next part where I want to calculate percentile.

each row(at date level) should show 3 color gradient in form of percentile/fractile function ex: green..yellow..red from 0 to 100%

DateLevel012345
5/12/2014-1250-75-
5/19/2014-322289745022
5/26/2014-202752239201
6/2/2014-229214118298123
6/9/2014-1,00636449237220
6/16/2014-2,34617521919525
6/23/2014-3,84712419632124

i have attached the spreadsheet and app

Community Browser