Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Luigi,

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

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

Regards,

Antonio

View solution in original post

5 Replies
antoniotiman
Master III
Master III

Hi Luigi,

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

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

Regards,

Antonio

Anonymous
Not applicable
Author

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
Author

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
Champion III
Champion III

Try like

= $(=vRate)

Not applicable
Author

thanks!