Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
su_pyae
Creator
Creator

Getting a specific value from the table based on the names of rows and columns in the script

Hello everyone, 

I have a table similar to this one. 

  100% 90% 80%
Year 1 2% 5% 9%
Year 2 4% 14% 20%
Year 3 10% 22% 35%
Year 4 25% 30% 50%

 

I would like to get the corresponding percentage based on the headers of rows and columns. 

For example, if it is Year 1 and 90%, I should get 5%. 

Year 1 90% 5%
Year 4 100% 25%
Year 3 80% 35%

 

Thank you for your help in advance. 

Labels (2)
0 Replies