4 Replies Latest reply: Sep 5, 2012 10:24 AM by grahhal89 RSS

    Can't convert to percentages...

      So I am very new to Qlikview so I apologize if this is simple.

       

      I have a table titled DCReason that lists reasons for discharges. This information is linked to another table titled Branches (these are our office branches).  I want to produce a graph that lists the discharge reasons and displays them as a percent so that when I click on a branch office, I can see what % of people were discharged for each reason.


      I've tried doing sum(DCReason)/sum(Total DCReason). I also tried playing around with the fractile function but nothing . All I am able to do is produce a graph taht shows the absolute number (Textcount (DCReason))

       

       

      DCReason.png2.png