20 Replies Latest reply: Jul 12, 2016 11:20 AM by Andrea Gigliotti RSS

    using expression in chart dimension background color

    Andrea Gigliotti

      ! !Hello,

      I need to use something like this in my pivot table dim

      ension background color:

      if( Dim1 = 'Value1', RGB(152, 187, 255) )

       

      i'm using set analysis in my pivot expression.

      the question is:

      why the above expression also affects the final result of aggregation sum ( {<...>} ) ?

      it seems set analysis is not being applied anymore.

       

      Can someone help me to understand why and if it works as expected ?

       

      Currently i'm using the version 12 SR4.

       

      Attached sample app: user = qlik password = view

       

      Many thanks in advance.

       

      Best Regards

      Andrea