Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)