Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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