Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
prananellutla
Contributor

Dynamic Filter on a Pivot table Row-Qlik Sense

Hi ,Using Qlik sense  is there a way to create a dynamic filter on pivot table rows,

In example below

A and B are 2 different fields.

when I select  A -which has values 1,2,3 the pivot table has to be my image 1

when I select B- which has values 4,5,6 the pivot table has to be my image 2

Example1.jpg

Thanks

Prana

1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

can't you see this?

Capture.PNG

What you do is creating a pivot table;

as dimension: ID

as measure (your expression; sum(sales) ?)

then add a column : country

Then under complement:

Capture.PNG

Enter this :

count(distinct YourFilterField)=1

With this way, your graphic won't show unless you select ONLY 1 FILTER ( A or B)

As for the default selections, please follow the thread I suggested you to follow

10 Replies
OmarBenSalem
Esteemed Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

Sure, can yous hare your QVF file? I'll show you how?

OmarBenSalem
Esteemed Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

See the attached app

Capture.PNG

Capture.PNG

Capture.PNG

prananellutla
Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

Omar-  thankyou for your time on this

I was still figuring out on how to attach qvf file to my reply.

what you have here is pretty much what iam looking for.

I am also looking for a default selection on value A and default visualization to be image 1.

do you mind sharing the .qvf here?

thanks

Prana

OmarBenSalem
Esteemed Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

the app is already shared;

as for default selections, please refer to this thread:

Default Selection in Qlik Sense

prananellutla
Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

Sorry all  I see is images. I  don't see an attachment to download qvf file and open in my desktop.

not sure how you loaded the data in filter? and how you passed the filter values to table on selection.

Initially I followed this thread to start my work.

How to use different filters on X and Y in a scatter plot?

but my connections are not working. thought I select my values nothing changes in the chart.

OmarBenSalem
Esteemed Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

can't you see this?

Capture.PNG

What you do is creating a pivot table;

as dimension: ID

as measure (your expression; sum(sales) ?)

then add a column : country

Then under complement:

Capture.PNG

Enter this :

count(distinct YourFilterField)=1

With this way, your graphic won't show unless you select ONLY 1 FILTER ( A or B)

As for the default selections, please follow the thread I suggested you to follow

prananellutla
Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

Thankyou - this is helpful.

prananellutla
Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

Hi Omar,

as an extension to this is there a way the row title dynamically changes based on the filter selected? I have read the threads - and also used the Dynamator extension mentioned in the thread here, it didn't work for me.

Emulating dynamic labels in Qlik Sense

Dynamic Label for Dimensions/Measures?

thanks for all your help .

sample row title.jpg

OmarBenSalem
Esteemed Contributor

Re: Dynamic Filter on a Pivot table Row-Qlik Sense

No, That won't be possible, but you can add the information in the Title for example:

='Dimension is '&GetFieldSelections(Dimension)

Capture.PNG