topic Re: using Set Analysis for Date Comparision in QlikView

using Set Analysis for Date Comparision

Anonymous — Wed, 09 Mar 2016 22:44:16 GMT

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

swuehl — Wed, 09 Mar 2016 22:57:26 GMT

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?

Gysbert_Wassenaar — Thu, 10 Mar 2016 07:14:36 GMT

See this document for an explanation: set_analysis_intra-record.qvw