error in expression

bushpalaamarnat — Mon, 21 May 2018 10:27:19 GMT

Hi All,

I have created this expression and in the chart it is giving desired output. how ever in the expression pop up window, it say's errors in expression. What am i missing?

could you help.

SFB

NUM(SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFB'}>}[FC: VALUE ERROR]) / SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFB'}>}[ACTUAL VALUE]), '##.00%')

SFA

=NUM(IF(SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[FC: VALUE ERROR]) / SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[ACTUAL VALUE]) > 1, 0,

IF(SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[FC: VOLUME]) * SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[ACTUAL VOLUME]) <= 0, 0,

1-(SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[FC: VALUE ERROR]) / SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[ACTUAL VALUE])))), '##.00%')

Re: error in expression

tresB — Mon, 21 May 2018 10:30:36 GMT

Try replacing the single quotes with double for like:

NUM(SUM({<SNAPSHOT_DATE = {"$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))"},....

Note: keep the single quotes used for date or number formatting

topic Re: error in expression in QlikView

error in expression

Re: error in expression