9 Replies Latest reply: Apr 12, 2018 12:13 PM by Ishtdeep Singh RSS

    Calculate percentage complete

    Dave Ski

      I have a report with each department (med affairs, clinical development, etc) and their employee training. The report has the training due date and the training completion date. I did an IF statement to populate ‘Compliant’ if they completed the training prior to the due date and ‘Non-Compliant’ for after due date.  I need to show the overall compliant/non-compliant percentage for each department. I did it in Excel and just did a pivot table that gave me the totals for each department and then manually calculated the %. Is there a way to set this up in Qlik so it will be easy each month? An example is below - I would like to present the bar chart below using Qlik Sense.