Qlik Community

Qlik Sense App Development

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

Partner
Partner

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

Re: Functioning of aggregation functions on a numeric value

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