2 Replies Latest reply: Dec 9, 2015 9:07 PM by Sasi Vardhan KV RSS

    Straight Table Filter

    Sasi Vardhan KV

      Hi,

       

      I have one small requirement, can any one help me.

       

      I have 2 straight tables, for eg:

       

      Group1ActualTargetVarianceMOM%
      Measure112-1-50%
      Measure223-1-33%
      Measure334-1-25%
      Measure445-1-20%
      Measure556-1-17%
      Measure667-1-14%
      Measure778-1-13%
      Measure889-1-11%
      Group2ActualTargetVarianceMOM%
      Measure912-1-50%
      Measure1023-1-33%
      Measure1134-1-25%
      Measure1245-1-20%
      Measure1356-1-17%
      Measure1467-1-14%
      Measure1578-1-13%
      Measure1689-1-11%

       

       

      The requirement is that, both group1 and group2 measures are coming from one single field but splitted based on some condition.

       

      now i need to display one trend graph, based on the measure selected from either one of the straight table.

       

      1. But the issue is that when ever we are selecting one meaure from one table the other table was going blank. this should not happen.

      whatever may be the selection from any table all the table rows should be displayed.

       

      2. When ever i am selecting the measure, the background color was going to white, this should not happen.

       

      3. currently for variance field we can see all the colour back ground colours, should have a funcitonality like if I click on the object all the variance rows except red color should be displayed.

        • Re: Straight Table Filter
          Stefan Wühl

          A small sample QVW helps to understand your setting, so if possible, upload a small sample application.

           

          In general, you can make your chart expressions insensitive to selections in field 'Measure' (I assume this is the name of your single field) by the use of set analysis.

           

          You need to apply set analysis to all aggregations functions in your expression. For example, if your expression for Actual is

           

          =Sum(Actual)

           

          then

           

          =Sum({<Measure= >} Actual)

           

          will disregard selections in field Measure, this should result in your dimension not filtered when selecting a measure line.