4 Replies Latest reply: Feb 11, 2016 8:16 AM by Clever Anjos RSS

    Expression Sum({<$(ColumnDim51)={"$(ColumnDim51)"}>}Amount)/1000 not working

    PAUL YEO

      Hi All

       

      I want to make 1 chart replace 2 chart by using diamension ?

       

      Objective to save number of table and sheet or to reduce number of chart for my QV Doc.

       

      Following is the step i did :-

       

      STEP (1) Below is the script that declare the diamension :-

       

      WhatIfDimension:

      LOAD * INLINE [

           Pls select 66 Dim,Column51

        rEVENUE,rEVENUE

        nET_PROFIT,nET_PROFIT

       

       

        ];

       

       

      STEP (2) After reload the script , i display field = Pls select 66 Dim on the sheet.

       

       

      STEP (3) At the same time I set variable :-

       

       

      I create new var = ColumnDim51

       

       

      Defination as :-

      =text('[' & (Column51) & ']')

       

       

      STEP (4) I use the below script :-

       

       

      Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

       

       

      Modify it become as below :-

       

       

      Sum({<$(ColumnDim51)={"$(ColumnDim51)"}>}Amount)/1000

       

       

      For chart 1 expression

       

       

      My Question is why chart 1 does not display any bar ? where i go wrong on the above expression ?

       

       

      As i except chart 1 display same as Chart A.

       

      I will send my QV doc in my next post.

       

       

      Paul