Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

(min) function in set analysis


I have dates and revenues for each date, DATE and REVENUE fields

When the user selects the range of DATE, I want to calculate sum of REVENUES for the minimum date in the selected range.

The formula does not work, why? I tried different ways and still don't get anything, unless I put the fixed date inside. Thank you!

Sum({<[DATE]={min(DATE)}>} [Revenue] )

Sum({<[DATE]={=min(DATE)}>} [Revenue] )

Tags (2)
3 Replies
Contributor III

Re: (min) function in set analysis

Contributor II

Re: (min) function in set analysis

The dollar sign solved it:


Valued Contributor

Re: (min) function in set analysis

Maybe you can close the discussion