Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

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
MVP & Luminary
MVP & Luminary

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