6 Replies Latest reply: Feb 15, 2017 1:52 PM by Vladimir Komarov RSS

    Ignoring selections in "Master items" fields in Set Analysis

    Vladimir Komarov

      Hello all,

       

      Looking for suggestion how to handle the following case:

       

      I do have a chart where Set Analysis is defined as following:

                sum({<Date = {"<=$(=date(vDR1End))>=$(=date(vDR1Start))"}, Master_Month = >} Sales)

      Where Date is the date-format field and Master_Month is one of the Master Items defined as =Month(Date)

      I just want to ignore the selection in Master_Month field, but QS is ignoring this option.

       

      The selections list is not even showing the "Master_Month" field. It's showing a function and the result of the selection:

      Screen Shot 2016-07-13 at 11.04.43 AM.png

       

      I am assuming it's happening due to Master Items' nature, but I would need to find a solution to workaround this functionality.

       

      Will appreciate an advice how to handle this case.

       

      Regards,

      Vladimir