Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
julioarriaga
Creator II
Creator II

Set analysis greater than a MIN(Date)

Hello,

I'm trying to create a greater than in this expression (which works correctly) but any > location in the = sign gives me nothing:

=SUM({<ConsecutivoFiscal={$(=MIN(ConsecutivoFiscal))}>}Bajas)

Kind regards.

1 Solution

Accepted Solutions
sunny_talwar

May be this

=Sum({<ConsecutivoFiscal = {">$(=MIN(ConsecutivoFiscal))"}>} Bajas)

View solution in original post

6 Replies
sunny_talwar

May be this

=Sum({<ConsecutivoFiscal = {">$(=MIN(ConsecutivoFiscal))"}>} Bajas)

vishsaggi
Champion III
Champion III

can we also write this way Sunny?

=Sum({<ConsecutivoFiscal = {"$(='>'&MIN(ConsecutivoFiscal))"}>} Bajas)

sunny_talwar

Sure .. that is how I usually write, but a lot of the people don't

vishsaggi
Champion III
Champion III

I have learnt this from one of your expression in a thread. 🙂

sunny_talwar

I like using what you have specified, but I see this getting used very rarely by anyone else. So, just thought of giving what others use today

vishsaggi
Champion III
Champion III

Agree. I have not seen many dev's using such way.