Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ziabobaz
Contributor II

(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
dsharmaqv
Contributor III

Re: (min) function in set analysis

ziabobaz
Contributor II

Re: (min) function in set analysis

The dollar sign solved it:

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

rupamjyotidas
Valued Contributor

Re: (min) function in set analysis

Maybe you can close the discussion