2 Replies Latest reply: Nov 25, 2015 10:40 PM by Prashant Sangle RSS

    Display only selected items from a subset limited by Set Analysis

    William Choo

      Hi, I have a list of sales records which are identified via their BatchCode and have created an expression to display them on a BarChart as follows:

      =Sum({<BatchCode={"ABC-001","ABG-002","AFG-005","XYZ-135","LMN-142".. }>}Revenue

       

      I have a List Box object that I use to list specific BatchCodes which I would like to analyze. The expression is as follows:

      =Aggr(

      if(BatchCode='ABC-001'

      or BatchCode='ABG-002'

      or BatchCode='AFG-005'

      or BatchCode='XYZ-135'

      or BatchCode='LMN-142'

      ...

      ,BatchCode),BatchCode)

       

      Currently, all my BatchCodes in the above set will always be shown, regardless of which BatchCodes I select.

      I would like to display only BatchCode(s) from this subset which I select, instead of displaying the entire list of BatchCodes.

       

      How should I change my expression to enable this?

       

      Thanks in advance!