7 Replies Latest reply: Jul 13, 2017 5:58 AM by mayuresh dabhekar RSS

    Create a custom Filter on Pivot table

    Pallav Abhishek

      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