1 Reply Latest reply: Nov 20, 2013 9:13 AM by Luis Cortizo RSS

    QlikView Server: QVWS service down

      Hi,

      Below is my set analysis coding,

       

      when i subtract Fiscal year It's subtracting from ASCII Code but actually i want subtract 1 year from my fiscal year, Highly appreciated if some one could me.

       

       

      (sum({<YearFiscal={$(=Max(FiscalYear))}>} SalesMT)-sum({<YearFiscal={$(=Max(FiscalYear-1))},LastYTDFlag={1}>} SalesMT))/sum({<YearFiscal={$(=Max(FiscalYear-1))},LastYTDFlag={1}>} SalesMT)

       

      Thanks,

       

      Raju