Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joey_lutes
Contributor

Set Analysis comparing 2 date fields

Can anyone tell me what's wrong with this code? (site.VerifiedDate and ReferenceDate are both date fields in different tables)

Sum({$<site.VerifiedDate={">=$(ReferenceDate)"},site.AddedDate={"<=$(ReferenceDate)"}>}site.Counter)

Date Format has been verified and works

Thanks!

1 Solution

Accepted Solutions

Re: Set Analysis comparing 2 date fields

Try this:

Sum({$<site.VerifiedDate={">=$(=ReferenceDate)"},site.AddedDate={"<=$(=ReferenceDate)"}>}site.Counter)

17 Replies

Re: Set Analysis comparing 2 date fields

There is only one value selected for ReferenceDate?

joey_lutes
Contributor

Re: Set Analysis comparing 2 date fields

Correct.

Re: Set Analysis comparing 2 date fields

Try this:

Sum({$<site.VerifiedDate={">=$(=ReferenceDate)"},site.AddedDate={"<=$(=ReferenceDate)"}>}site.Counter)

joey_lutes
Contributor

Re: Set Analysis comparing 2 date fields

That worked!

Thanks as always!  You're the S-A KING!

Re: Set Analysis comparing 2 date fields

S-A Queen?? What's that??

joey_lutes
Contributor

Re: Set Analysis comparing 2 date fields

Set Analysis of course

Re: Set Analysis comparing 2 date fields

S-A King you mean....

joey_lutes
Contributor

Re: Set Analysis comparing 2 date fields

  My sincere apologies.  King it is! (very small picture).  I'll update the post accordingly.

Begging forgiveness!!

Thanks again for the help.

Re: Set Analysis comparing 2 date fields

no worries

Community Browser