8 Replies Latest reply: Feb 8, 2017 4:34 PM by Akash Patel RSS

    How to calculate % expression by a  specific variable in a straight table

    Akash Patel

      Hi,

       

      In the attached excel file, I have provided an example of  what I am trying to do in my qlikview dashboard. But I am not able to come up with  a solution to achieve it. If someone can help me, that'd be a big help.

       

      Explanation of what I want to achieve

      - There are two dimensions 'Agent Name' and 'Date' associated with the 'Agent Name'. Then there is one expression column 'Availabitly %' which gives a percentage value. I need to create another expression, which first checks if the 'Availabitly %'value is greater than 80% and if yes then count the date for that particular row divide it by total count of # of dates for that particular agent.

       

      Thanks!

      Akash