topic Re: Expression not returning the value associated with latest date in App Development

Expression not returning the value associated with latest date

qlikbbguser — Sun, 25 Aug 2024 21:11:08 GMT

hi all,

I have this expression hoping to return the 'Sales Revenue' as of latest date (based on the QlikDate field). but it returns the sum of sales revenue for ALL dates - any clue why?

the 'QlikDate_short' field is just the 'QlikDate' field converted to date format.

Example:

QlikDate = 07/01/2023

QlikDate_short = 7/1/2023

Re: Expression not returning the value associated with latest date

Lisa_P — Sun, 25 Aug 2024 23:19:02 GMT

change the QlikDate_Short to:

QlikDate_Short={'$(=date(max(QlikDate), 'M/D/YYYY'))'}

Re: Expression not returning the value associated with latest date

qlikbbguser — Mon, 26 Aug 2024 13:15:12 GMT

Thank you.

Unfortunately it returns 'Error in expression = {'-'}

Re: Expression not returning the value associated with latest date

nina2 — Mon, 26 Aug 2024 13:34:29 GMT

Hi,

It seems QlikDate_Short is not a dimension

Why not like this :

sum(

QlikDate={$(=max({<Source={'SAP - Hist Terminal'}>}QlikDate))},

[Metric Name]={'Sales Revenue'},Source={'SAP - Hist Terminal'}

Value)

Regards,

Nina

Re: Expression not returning the value associated with latest date

Or — Mon, 26 Aug 2024 13:37:38 GMT

QlikDate_Short isn't being recognized as a field. Are you sure it's there? It should be colored the same as the other fields in that oddball shade of... fallow? Same as Source, Value, etc.

Re: Expression not returning the value associated with latest date

Lisa_P — Mon, 26 Aug 2024 23:12:13 GMT

I think it's just a typo for the field name ..

QlikDate_short not QlikDate_Short