Filtering Measures in Pivot Table

[snehal1405]

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.

[zzyjordan]

Hi,
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

[snehal1405]

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.

[zzyjordan]

Hi,
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

[snehal1405]

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?

[zzyjordan]

Yes, it is possible. As I mentioned earlier, you can use cross table, but the script will depend on what your data structure looks like. but I think it should doable.

ZZ

[snehal1405 · Accepted solution]

Thanks! I used an index() condition and it worked. Thanks for your time.

[CaBolba]

Hi

Can you elaborate how did you do that. I also want to be able to filter my measures in a pivot table.

[jasmina_karcic]

Hi, how did you make this pivot table?

I need this 😄 please give me instructions...

thanks

Jasmina