Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 (4)
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.