
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Filtering Measures in Pivot Table
Hi Everyone,
I've made a pivot table in Qlik Sense where I'm trying to filter different measures.
I want the user to able to select the values they would like to see from the filter pane and the pivot table should only display the selected values.
However, I'm having trouble linking those two. I have attached a picture below for reference.
Thanks in advance.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks! I used an index() condition and it worked. Thanks for your time.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It will be easier if you pivot your measures in load script using cross table so that the measure names could become as dimension name and use it for filter purpose.
below is the link for your reference.
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-c...
ZZ

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey,
I'm trying to create something like this:
https://www.youtube.com/watch?v=iBfFaLnoPRU
Filter of 'Measures' and 'Dimension' to choose what they want to add in the pivot table.
How can I make that filter?
Thanks.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I understand that, but it seems you have multiple measures in your rows and they are actually not dimension, that's why your filter isn't work. Could you mock up a simple app with some dummy data but reflect your issue, then it will be easier for me to show step by step of how to achieve it?
ZZ

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, you're right. It is a list of calculated measures.
I added an extra column in my database using load script to display this new column with all calculated measures but, I'm not able to figure out how to list them out in a filter.
Is it possible?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ZZ

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks! I used an index() condition and it worked. Thanks for your time.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Can you elaborate how did you do that. I also want to be able to filter my measures in a pivot table.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, how did you make this pivot table?
I need this 😄 please give me instructions...
thanks
Jasmina
