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%
| Date | Level | 0 | 1 | 2 | 3 | 4 | 5 |
| 5/12/2014 | | - | 12 | 50 | - | 75 | - |
| 5/19/2014 | | - | 322 | 289 | 74 | 50 | 22 |
| 5/26/2014 | | - | 202 | 75 | 2 | 239 | 201 |
| 6/2/2014 | | - | 229 | 214 | 118 | 298 | 123 |
| 6/9/2014 | | - | 1,006 | 364 | 49 | 237 | 220 |
| 6/16/2014 | | - | 2,346 | 175 | 219 | 195 | 25 |
| 6/23/2014 | | - | 3,847 | 124 | 196 | 321 | 24 |
| | | | | | | |
i have attached the spreadsheet and app
