topic Re: Set Analysis with dates in QlikView

Set Analysis with dates

Mon, 26 Jan 2026 16:26:21 GMT

Hi All,

this works:

=count ( {$<AnalysisDate={">=8/9/17"}>} Rate)

this doesn't work:

=count ( {$<AnalysisDate={"=8/9/17"}>} Rate)

this doesn't work:

=count ( {$<AnalysisDate={">=$(max(DateTo))"}>} Rate)

*DateTo is a Field, max(DateTo) should give 8/9/17

suggestions?

thanks!

Luigi

antoniotiman — Fri, 11 Aug 2017 00:28:01 GMT

Hi Luigi,

=count ( {$<AnalysisDate={'8/9/17'}>} Rate) // = sign removed

=count ( {$<AnalysisDate={'>=$(=max(DateTo))'}>} Rate)

Regards,

Antonio

Anonymous — Fri, 11 Aug 2017 06:49:29 GMT

this doesn't work:

=count ( {$<AnalysisDate={"=8/9/17"}>} Rate)

this will work

=count ( {$<AnalysisDate={"8/9/17"}>} Rate)

this doesn't work:

=count ( {$<AnalysisDate={">=$(max(DateTo))"}>} Rate)

this will work

=count ( {$<AnalysisDate={">=$(=max(DateTo))"}>} Rate)

Fri, 11 Aug 2017 19:36:56 GMT

it works, thank you!

now I have a new problem, if I create the variable

set vRate=count ( {$<AnalysisDate={">=$(=max(DateTo))"}>} Rate);

and I try to solve the variable in the expression

=$(vRate)

I don't get the value

vishsaggi — Fri, 11 Aug 2017 19:42:30 GMT

Try like

= $(=vRate)

Tue, 15 Aug 2017 14:06:39 GMT

thanks!