1 Reply Latest reply: Oct 23, 2015 4:57 AM by PAUL YEO RSS

    Why not QS support the expression = What If Dimension, Column1 ?

    PAUL YEO

      Hi All

       

      (A) My QV Expression for LY  is not suitable for use in QS :-

      money(

      sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

      (B) Because of  QS Does not allow us for create load script below :-


      What If Dimension, Column888  

       

      (C) My solution end up using QS Variable :-

       

      which is not support QS cloud.

       

      (D) My Requirement are :-

       

      Allow you change the Amount display in Local currency or other country currency. select the diamension , and change the expression amount.

       

      And my QV old expression is not support

       

      (E) My Question :-

       

      it there any other alternative ? So that my QV old table and chart can be display at QS.

      QS can develop such report.png