Represent the percentage of Attendance ONLY for the selected data row in a Pivot Table

[andymanu]

Hi All,

I got a small app and want to represent the attendance related data for each session conducted under individual "Staff Team". (Please refer the attached "Selecting under Project Manager" screen shot).

However, when I selected the individual data row under the Project Manager, by default it will select all the respective Sessions under each "Staff Team". (for example, Sales Manager and Accountant) 

Please refer attached "Effective Selection" screen shot herewith.

Thus the issue is, when I select a single row (under Project Manager), I should get the Gauge percentage figure as 100% according to the pivot table which is correct, but it reflect 67%.

I have also attached my sample "QVF" file herewith and appreciate if someone could help me to address this issue.

Thank you very much in advance.

Kind regards,

Andy

[andymanu]

Unfortunately, Qlik Sense is not allowing me to upload my QVF file

Could anyone please tell me how to resolve this issue?

Andy

[andymanu]

Hi,
I am at work now and don't have WinZip on my computer.
Once I get back, i'll zip the QVF file and upload it.
Regards,
Andy

[andymanu]

Hi All,

Please find the attached qvf zipped file herewith.

Appreciate your help.

Kind regards,

Andy