topic Re: QlikView Server: QVWS service down in Archived Groups

QlikView Server: QVWS service down

Tue, 22 Jul 2025 17:59:49 GMT

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

Re: QlikView Server: QVWS service down

Luis_Cortizo — Wed, 20 Nov 2013 14:13:38 GMT

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