3 Replies Latest reply: Aug 12, 2017 7:00 AM by wade taylor RSS

    Using Variable in bar chart

    siva bose

      Hi all,

       

      I have the below expression in a bar chart. Is it possible to store this in a variable and use it for multiple charts.

       

      "=if(GetFieldSelections(Properties)='WithoutProperties'and GetFieldSelections(Reusability)='Output', count(DISTINCT {<BOFF={'Y'}>} OutputWithoutProperty),

      if(GetFieldSelections(Properties)='WithProperties'and GetFieldSelections(Reusability)='Output', count(DISTINCT {<BOFF={'Y'}>} OutputWithProperty),

      if(GetFieldSelections(Properties)='WithoutProperties'and GetFieldSelections(Reusability)='Input', count(DISTINCT {<BOFF={'Y'}>} InputWithoutProperty),

      if(GetFieldSelections(Properties)='WithProperties'and GetFieldSelections(Reusability)='Input', count(DISTINCT {<BOFF={'Y'}>} InputWithProperty),

      if(GetFieldSelections(Properties)='WithoutProperties'and GetFieldSelections(Reusability)='Both', count(DISTINCT BothWithoutProperty),

      if(GetFieldSelections(Properties)='WithProperties'and GetFieldSelections(Reusability)='Both', count(DISTINCT BothWithProperty)))))))"


      Please help. Also attached the QVW file.

       

      Thanks,

      Siva.