Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why does
this works: - =count(if(%Check_Key = %Key and [Date 1] >= '12/12/1999', ID))
but this does not: -
=count({$ <%Check_Key = P(%Key), [Date 1] ={">= 12/12/1999"}>} ID)
I already checked the '%Check_Key = P(%Key)' part; it works without the date parameters. so no issues there.
I just want to know why set analysis does not like date comparisons or may be i am doing it wrong.
Thanks again
First, please note that
=count(if(%Check_Key = %Key and [Date 1] >= '12/12/1999', ID))
will evaluate the comparisons on a per record base, while the set analysis won't.
Regarding the date comparison, have a look at
Have you check the format of [Date 1] values, that they match format of the set modifier?
See this document for an explanation: set_analysis_intra-record.qvw