(min) function in set analysis

[ziabobaz]

Hi!

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] )

[dsharmaqv]

Try this

Set analysis for max date value? | Qlik Community

[ziabobaz]

The dollar sign solved it:

Sum({<Дата={"$(=min(Дата))"},[Revenue])

[rupamjyotidas]

Maybe you can close the discussion