Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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)