topic Re: Filtering Measures in Pivot Table in App Development

Filtering Measures in Pivot Table

snehal1405 — Sat, 16 Nov 2024 21:35:04 GMT

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.

Re: Filtering Measures in Pivot Table

zzyjordan — Fri, 18 Jan 2019 00:16:39 GMT

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-cross-tables.htm

ZZ

Re: Filtering Measures in Pivot Table

snehal1405 — Fri, 18 Jan 2019 00:41:31 GMT

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.

Re: Filtering Measures in Pivot Table

zzyjordan — Fri, 18 Jan 2019 02:43:56 GMT

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

Re: Filtering Measures in Pivot Table

snehal1405 — Fri, 18 Jan 2019 13:23:50 GMT

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?

Re: Filtering Measures in Pivot Table

zzyjordan — Fri, 18 Jan 2019 19:07:39 GMT

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

Re: Filtering Measures in Pivot Table

snehal1405 — Mon, 28 Jan 2019 14:05:47 GMT

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

Re: Filtering Measures in Pivot Table

CaBolba — Tue, 09 Jul 2019 19:01:37 GMT

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

Re: Filtering Measures in Pivot Table

jasmina_karcic — Wed, 10 Jul 2019 09:29:17 GMT

Hi, how did you make this pivot table?

I need this 😄 please give me instructions...

thanks

Jasmina