Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
NikosSpanos
Contributor III
Contributor III

Make row selection in a pivot table that has a ValueList() as row labels

I have the following table (see also qvf file attached)

Screenshot_5.png

The rows and the columns are created based on ValueLists. However, when I try to select a specific row to see only the data related to that row, I can't filter the table. I know that this is happening because I use a ValueList as a dimension and not a loaded dimension from my data.

Could you please suggest any way to filter/select rows or column created by ValueLists. I ave found the below thread as relevant to what I want to achieve by using an Island table. Is this the only solution so far?

Relevant thread: https://community.qlik.com/t5/Qlik-Sense-App-Development/How-to-filter-data-based-on-hardcoded-filte...

 

Labels (3)
1 Reply
Or
MVP
MVP

Looks like you did indeed find the solution - using an island table. That thread also explains why this is the case - with ValueList or ValueLoop, there's nothing for Qlik to actually select when you click on the measure as those values aren't associated with any fields.