Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Pragun
Partner - Contributor II
Partner - Contributor II

Functioning of aggregation functions on a numeric value

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. 

1 Reply
marcus_sommer

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