4 Replies Latest reply: May 27, 2017 3:43 PM by Koen Bal RSS

    Adhoc Reporting

    ben lim

      Hi all, I am currently doing an adhoc Interface for QV user to retrieve data on the table.


      I have a list of selection fields where when user click, the specific dimension/expression will show on the table.


      However, on my expression, I have TEU and Transit_TEU


      Using Calculated Condition, I tried using

      =SubStringCount(Concat(_Dimension, '|'), 'Transit_TEU')


      as well as


      =SubStringCount( Concat(DISTINCT _Dimension) ,'Transit_TEU')


      It appears Transit_TEU and TEU which is not the output that I am looking for


      any advise for this