Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bushpalaamarnat
Creator
Creator

error in expression

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%')

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

View solution in original post

1 Reply
tresesco
MVP
MVP

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