# QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Not applicable

## Set Analysis with dates

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

Tags (1)
1 Solution

Accepted Solutions
Honored Contributor III

## Re: Set Analysis with dates

Hi Luigi,

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

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

Regards,

Antonio

5 Replies
Honored Contributor III

## Re: Set Analysis with dates

Hi Luigi,

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

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

Regards,

Antonio

Contributor II

## Re: Set Analysis with dates

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)

Not applicable

## Re: Set Analysis with dates

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

Esteemed Contributor III

Try like

= \$(=vRate)

Not applicable

thanks!