4 Replies Latest reply on Jun 20, 2016 2:22 PM by Nandhakumar Ramanathan

    Hide a filter value

    Nandhakumar Ramanathan

      Hi,

       

      I am using below calculated filed as a filter

       

       

      CASE  [Service]

      when 'Services AS Rating' then 'AS Rating'

      when 'Services Commercial Underwriting' then 'Comm Underwriting'

      when 'Services NS Rating' then 'NS Rating'

      when 'All Personal' then 'All Personal'

      when 'Services SPRS' then 'SPRS'

      when 'Services Wind Inspecting' then 'Wind Inspection'

      when 'Services PCA' then 'PCA'

      Else 'Unknown'

      End

       

      I want to hide the "Unknown" in the filter used in the dashboard. How can i achieve this?

       

      Regards,

      Nandha

        • 1. Re: Hide a filter value
          jason.harmer

          Creating a set based on the objects of your case calculated field will allow you to include all values but unknown. Then, drag the set into the filter shelf and "show all." All values in the set will be visible, but any values not in the set (aka the unknown value) will not be visible by the end user.

          1 of 1 people found this helpful
          • 2. Re: Hide a filter value
            Nandhakumar Ramanathan

            Hi Jason,

             

            Thanks for the swift reply.

             

            I am using this filter in multiple dashboards and worksheet. I tried this set concept but i am not able to apply this values for selected worksheets, I mean I am not able to see all the sheets in the selected worksheet popup. So I am not able to select the work sheets which i want to use this filter.

             

            Regards,

            Nandha

            • 3. Re: Hide a filter value
              jason.harmer

              Not sure I gather what you mean. You should be able to apply sets just like another other dimension or measure, across multiple tabs or dashboards. Are you able to post a copy of your workbook for a closer look?

              • 4. Re: Hide a filter value
                Nandhakumar Ramanathan

                Hi Janson,

                 

                I am not position to attache the workbook here. So I have attached the images below. Please refer the below images.

                 

                First image is filter if I select Apply to Worksheets ----> Selected worksheets in this I am seeing more worksheets.

                But second image is the set if I select  Apply to Worksheets ----> Selected worksheets in this I am seeing only few worksheets.

                Can you please help me here

                 

                Filters_Cancell.PNG

                Filters_Cancell_Set.PNG

                 

                Regards,

                Nandha