New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Global Transformation Awards! Applications are now open. Submit Entry

Who Me Too'd this solution

petter
Partner - Champion III
Partner - Champion III

When you use Max or Min on a date Qlik will remove the text format of the date and just keep the numeric part. So be sure to wrap the Max and Min in a Date()-function to reapply the correct time format:

vFromDate = Date(Max(FromDate));

vToDate = Date(Max(ToDate));

The expression should then be:

=If( BusinessDate > vFromDate AND BusinessDate < vToDate,BusinessDate )

or

=If( BusinessDate > '$(vFromDate)' AND BusinessDate < '$(vToDate)' ,BusinessDate )

View solution in original post

Who Me Too'd this solution