6 Replies Latest reply: Feb 24, 2016 2:23 AM by Maarten Van Damme RSS

    Set analysis ignores my sub-selection when defined a range of values

    Maarten Van Damme

      Hi,

       

      I defined in the expression to only view a specfic set of data, but I might want to view only a sub-part of the presentation by selecting one (or more) of the possible values. Unfortunately, I don't know how to do this... It always sticks to the selections made in the set analysis expression. Since 'C' is a value of the array 'A,B,C,D,E' I would think this should work?

       

      1.png

       

      Script:

      Test:

      load * inline [

      Name, Salary

      A,10

      B,20

      C,30

      D,40

      E,50];

       

      Set analysis expression: sum({<[Name]={'A','B','C','E'}>} Salary)