Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
change the QlikDate_Short to:
QlikDate_Short={'$(=date(max(QlikDate), 'M/D/YYYY'))'}
Thank you.
Unfortunately it returns 'Error in expression = {'-'}
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
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.
I think it's just a typo for the field name ..
QlikDate_short not QlikDate_Short