I recently asked how to write a set expression that would select the last run time (regardless of selection) using a date variable (calendar_dt) and a time variable (batch_time). The solution was
=time(max({1<calendar_dt={"$(=maxstring({1}calendar_dt))"}>}batch_time))
There is a third datetime variable in the data, batch_dttm, that has the format (DDMMMYY:hh:mm) and the data also has a variable that gives the server name (hostext).
I want to display the max value of a variable (measure) for each server (dimension) regardless of selection FOR the last run time. I have been studying "Les set analysis_ENG.pdf" that I found in the forums, but the proper syntax is still eluding me.
I have the following:
Max({1<hostext={S1234}, batch_dttm={'$(=Maxstring({1}timestamp#(batch_dttm,'DDMMMYY:hh:mm')))'}>}var1)
It returns a dash (-) However, I get a result if I hard code a batch_dttm, by replacing the red text with a value, for example:
Max({1<hostext={S1234}, batch_dttm={'15MAR19:20:00'}>}var1)
Why is the dollar expansion not working? How does qlik resolve it? When do you need a preceding equal sign?
