topic Re: set analysis in a variable in QlikView

set analysis in a variable

Fri, 15 Jan 2016 16:46:30 GMT

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.

sunny_talwar — Fri, 15 Jan 2016 18:08:22 GMT

May be:

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

rikrdodata — Fri, 15 Jan 2016 18:16:40 GMT

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

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

maxgro — Fri, 15 Jan 2016 18:18:50 GMT

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