QlikView Server: QVWS service down

[#1]

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

[Luis_Cortizo]

Try this instead:

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

But I'm sure that the Deployment Framework group is not the best place to place this kind of question