Hi, I am new to Qlik Sense, I need to create a Learning Dashboard in which, we have to showcase the training titles along with 2 measures which are the people who have enrolled in those session in one column and people who enrolled in the training title in another column.
To get numbers of People enrolled and attended people, I have used this formulae:
if(match("Registration Status",'Enrolled'),"Registration Status") as Enrolled Participants
if(match("Course Attendance Status",'Attended'),"Course Attendance Status") as Attended Participants
Now the need is:
1. I need to get their sum totals in the top row
2. I need to create a New column (Partcipation Percentage) which will be dervied from:
(Attended Particiants / Enrolled Participants)* 100
Issue i am facing while doing it:
1. For the 1st need, I am not able to see show totals in Presentation tab, how can i get this resolved.
2. For the 2nd need, I tried writing down the above mentioned formula in the Data Script but it is showing as 0
Here is the image attached for your reference
![Himanshu_Mahajan_0-1722334938163.png Himanshu_Mahajan_0-1722334938163.png](https://community.qlik.com/t5/image/serverpage/image-id/170066iDE94C14F3F0AB67E/image-size/medium?v=v2&px=400)