This content has been marked as final. Show 3 replies
Hello Qlik Community,
Can anyone help with an expression or technique that would help isolate the "peak" value of a cumulative expression, when assigned in a straight table?
In the following set of records, I'd like to be able to isolate when the cumulative value peaked, and what that peak value was, but if possible by doing this entirely in user-interface (i.e. not adding any aggregation tables, or rescripting).
Is there a way to isolate the cumulative maximum of an expression when aggregated across a dimension?
LOAD * INLINE [