Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

(min) function in set analysis

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

Tags (2)
3 Replies
Highlighted
Creator III
Creator III

Re: (min) function in set analysis

Highlighted
Creator III
Creator III

Re: (min) function in set analysis

The dollar sign solved it:

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

Highlighted
Specialist
Specialist

Re: (min) function in set analysis

Maybe you can close the discussion