Create a custom Filter on Pivot table

[#1]

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

[sunny_talwar]

May be see this

Buckets

[beck_bakytbek]

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

I hope that helps

Beck

[#4]

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]

Hi Pallav,

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

Thanks,

Arvind Patil

[mayuresh_d]

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.

[#7]

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

[mayuresh_d]

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

thanks