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
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
Create buckets of required filter,
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.