0 Replies Latest reply: Sep 2, 2015 7:05 PM by ria Desai RSS

    conditional formatting with percentage values and percentile colors

    ria Desai

      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