conditional formatting with percentage values and percentile colors
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%