1 Reply Latest reply: Oct 13, 2017 7:59 AM by Sunny Talwar RSS

    Set analysis combined with other filter

    Theis Høvring



      I have a table with columns using the following set analysis expression:

      COUNT( {$ <PROCTYPE =-{''} >} SKSKODE )


      PROCTYPE includes:

      - Proc_A

      - Proc_B

      - etc.


      - NULL values, with I sort out using set analysis expression above.


      I want my table to filter on for instance Proc_A, but the expression in my set analysis overrides the filter and my table shows all columns where PROCTYPE is not null not regarding the filter. Is it possible to only show for instance Proc_A without making another variable to use only in the set analysis expression?