4 Replies Latest reply: Oct 12, 2017 4:28 PM by Suraj Kumar RSS

    filter

    Suraj Kumar

      Hi All,

       

      I want to create a field or a front end expression to filter rows in Status field.

      The user should have 2 values to choose- Top, All.

       

      When All is selected, show all products. If Top is selected show only products with status Yes.

       

      Data:

      LOAD * INLINE [

          Product, Status

          A, YES

          A, YES

          B, YES

          C, NO

          D, NO

      ];

       

      I created this filter but it is not working

      if(Status = 'YES' or Status = 'NO','All',

      if(Status = 'YES','Top'))


      Please help.