Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried the functions max and only on a numeric value and got the following results.
max(2000) and only(2000) returned nothing (Null) but, when I tried max(2000*1) and only(2000*1) it returned 2000 . I am unable to understand why.
I think Qlik interpret the 2000 as field(-name) and I assume there is not such a field. With the * 1 it recognized it as calculation.
- Marcus