topic Re: How to select 2 fields in Pivot Table in QlikView

How to select 2 fields in Pivot Table

s10157754 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to select 2 fields in Pivot Table

Gysbert_Wassenaar — Sat, 17 Nov 2018 10:00:48 GMT

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.

Re: How to select 2 fields in Pivot Table

s10157754 — Sat, 17 Nov 2018 10:08:34 GMT

Dear Gysbert,

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

Best Regards
QianNing

Re: How to select 2 fields in Pivot Table

Gysbert_Wassenaar — Sat, 17 Nov 2018 10:12:45 GMT

You're welcome! Have a nice day.