Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Highlighted
andymanu
Contributor

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

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

Labels (2)
3 Replies
andymanu
Contributor

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

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

Could anyone please tell me how to resolve this issue?

Andy

andymanu
Contributor

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

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
Contributor

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

Hi All,

Please find the attached qvf zipped file herewith.

Appreciate your help.

Kind regards,

Andy