Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

snehal1405
New Contributor II

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.

 

1 Solution

Accepted Solutions
snehal1405
New Contributor II

Re: Filtering Measures in Pivot Table

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

8 Replies
Highlighted
zzyjordan
Contributor II

Re: Filtering Measures in Pivot Table

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
New Contributor II

Re: Filtering Measures in Pivot Table

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
Contributor II

Re: Filtering Measures in Pivot Table

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
New Contributor II

Re: Filtering Measures in Pivot Table

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
Contributor II

Re: Filtering Measures in Pivot Table

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
New Contributor II

Re: Filtering Measures in Pivot Table

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

Partner
Partner

Re: Filtering Measures in Pivot Table

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
Contributor II

Re: Filtering Measures in Pivot Table

Hi, how did you make this pivot table?

 

I need this 😄 please give me instructions...

 

thanks

 

Jasmina