Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardoramiro
Contributor
Contributor

How to use only data with a specific date in the expression editor?

Hi!

Is there a way to do something that performs the same function as this "Where" in an expression editor?

 

where extract_dt = (select min (extract_dt) from governanca_dado.fsimage)

 

My column "extract_dt" has two dates, one is recent and the other a date from the last month. I have these dates so I can compare the old data with the current one and get a sense of the changes.

I wanted the expression to use only data that have that minimum or maximum date, for example, to generate data.

Labels (2)
1 Reply
Bunim
Contributor III
Contributor III

aggr(only({<extract_dt={$(=min(extract_dt))}>}extract_dt),extract_dt)