2 Replies Latest reply: Sep 21, 2016 11:56 AM by neelam sehrawat RSS

    count distinct based on 2 conditions

    divya anand

      Hi,

       

      Could someone help me in writing the expression which should fetch the count of distinct values based on 2 conditions?

       

      For example:

       

      In the screenshot, there are 2 list boxes with 2 different expressions. How do I fetch the count of distinct values in both the list boxes combined?

      That is, by seeing the list boxes I know 003, 005 appear in both list boxes, however I would like to have the count of distinct values from both the list boxes combined. (conditions).

      So, according to the data in the screenshot, The value I want is "9" because I have 9 distinct values from both the list boxes combined.

       

      Note: Working on the script side doesn't work for this case because the condition is triggered by selections in the layout.

       

      I am attaching the qvw for reference.

       

      Thank you.