Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Create a custom Filter on Pivot table

Dear All,
I have a created a pivot with some measured columns in Qlik sense.
My pivot is something like the image attached.
I basically need two filters as shown in image.

Through these filters I want to select value depending upon the GM and Realisation.
I tried adding a measured column in which I was assigning every client to revenue Band, But the formula was becoming very complex and was not even serving my purpose as I was not able to add this measure to filter.

I am trying to do filtration based on FY17 Data only

Capture.PNG

Tags (1)
7 Replies
MVP
MVP

Re: Create a custom Filter on Pivot table

May be see this

Buckets

beck110979
Valued Contributor III

Re: Create a custom Filter on Pivot table

look at this:https://community.qlik.com/thread/257523

I hope that helps

Beck

Not applicable

Re: Create a custom Filter on Pivot table

Thanks Beck and Sunny,
Thing is I am quite new to Qlik ,just started using a day back

I am not getting where to use this script and also can I use my Created Measures in this formula.
I basically want two Filters .

Just to add I am using QlikSense

arvind_patil
Valued Contributor II

Re: Create a custom Filter on Pivot table

Hi Pallav,

As per my point of view, You need to create buckets at the script level.

Thanks,

Arvind Patil

mayuresh_d
Contributor

Re: Create a custom Filter on Pivot table

hi,

Create buckets of required filter,

like

if(gross Market<20,'below 20',

if(gross Market>=20 and gross Market<30,'20 to 30',

if(gross Market>=30 and gross Market<40,'30 to 40',

if(gross Market>=40,'above 40'))) as GM

use same for another

filter then add this in pivot base table then you can use them as slicer,


we use slicer in excel as an filter.

where just select pivot and then you will find slicer option in insert tab,

after selecting slicer it will show a option list select whatever slicer you want.

Not applicable

Re: Create a custom Filter on Pivot table

Hi Mayuresh,
I am not getting any option to create a bucket in Qliksense.
Can you please please guide.?

mayuresh_d
Contributor

Re: Create a custom Filter on Pivot table

use above expression in script, there is no option to create buckets in qliksense you have to write script for that.

thanks