How to select 2 fields in Pivot Table

[s10157754]

Dear Qlikview Experts,

I have insert my raw data and created a straight table in Qlikview.

 

Is there anyway when I click on anyone of the numbers in the table, then the relevant 'Student' & 'Result' would be selected at the same time? Instead of only 'Result' being selected. Any solution to achieve similar outcome would be greatly appreciated!

I have attached my sample raw file and qvw for your reference. Thank you! 

Best Regards

QianNing

[Gysbert_Wassenaar · Accepted solution]

No, that's not possible. Clicking on the value of an expression in a straight table or pivot table will only select the dimension values that were used to calculate that value. What you can do is use a pivot table with Result and Student as dimensions and one expression. Then when you click on a value the Student will be selected too. See atteched example.

[s10157754]

Dear Gysbert,

Thank you for your prompt reply and your solutions works perfectly for me.

Best Regards
QianNing

[Gysbert_Wassenaar]

You're welcome! Have a nice day.