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.
IF("Training Completion">"Due Date", 'NonCompliant','Compliant') as Compliant
I get a new field that shows NonCompliant or Compliant for each person. I see that your way is similar but a little different. With your way, would I be able to do a stacked bar chart showing the %compliant and %noncompliant for each department? Right now, I have a pivot table set up in Qlik that gives me the count of compliant and count of noncompliant for each department and I have to export the pivot table so that I can use it to generate a bar chart in excel.