9 Replies Latest reply: Mar 8, 2018 12:16 PM by Farrukh Shaikh RSS

    Aggr Set Analysis Calculated Dimension with Variable

    Farrukh Shaikh

      Hi All,

       

      I have created an expression in Calculated Dimension but its not showing the result. Can you please advise me where I am having an issue. If I removed the ( Draw={"=$(=Draw_EM)"} ) this part then its work but when I restrict by field selection Draw then its showing blank.

       

      I have attached the qvw file.

       

      Draw_EM is a Variable:

      =if(GetSelectedCount(Draw) > 0 , GetFieldSelections(Draw), 'EM+')

       

      Calculated Dimension:

      =Only({$<Draw={"=$(=Draw_EM)"}, Period={">=$(=vPeriod_EM)"}>} Draw)

       

       

      Expression:

      =Count({$<Draw={"=$(=Draw_EM)"}, Draw = {"=$(=Draw_EM)"}, Year = {"2017"}>} F2)

       

      Kind regards,

      Farrukh