3 Replies Latest reply: Oct 20, 2014 9:31 PM by jagan mohan rao appala RSS

    Percentage of another function in pivot table

      Hello-

       

      I am fairly new to qlikview and i am trying to fix the below issue:.

       

      Below is my pivot chart in qlikview. I want to make the percentage as a function of the total carton count per time.

       

      Here is an example:

       

      For time as 0, on time as late and carton count as 449. The percentage should be 449/ 1136.

       

      For time as 0, on time as on time and carton count as 687- the percentage should be 687/ 1136.

       

      TimeOn Time PerformanceCarton CountPercentage
      0:00:00Late449100%
      0:00:00On Time687100%
      0:00:00Total1136100%

       

      I also have this chart repeat with different times (ex. 1, 2, 3, 4) and I want the same expression to follow the same logic.

       

      Please let me know if you could help.


      Thanks.