Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis in a variable

I am setting a variable in variable overview from document setting to evaluate a set analysis like

=min({$<DATEA={'$(>=DATE(vCurrentdd-10))'} >}  DATEA))

It evaluates to "-". However, in straight table this  expression shows the next business day in the database correctly.

3 Replies
sunny_talwar

May be:

=Min({$<DATEA={"$(>=Date(vCurrentdd-10, 'YourDateFieldFormatHere'))"}>} DATEA)

rikrdodata
Partner - Contributor III
Partner - Contributor III

=min({$<DATEA={'$(>=DATE($(=vCurrentdd-10)))'} >}  DATEA))


or


=min({$<DATEA={'$(>=$(=DATE($(=vCurrentdd-10))))'} >}  DATEA))

maxgro
MVP
MVP

min({$ <DATEA={">=$(=Date(vCurrentdd-10, 'YourDateFieldFormatHere')  ) ">} DATEA)