Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Date Filtering - Qilk Sense

Good Morning Everyone,

I am trying to build a formula that would filter the number of new accounts that my Sales Team opened in the last 120 days.

My Field is called OPNDAT and the formatting is M/DD/YYYY HH:MMSmiley FrustratedS AM

Thanks

Tags (1)
1 Solution

Accepted Solutions
sinanozdemir
Valued Contributor III

Re: Date Filtering - Qilk Sense

Hi Barry,

You can try to handle this in your WHERE clause:

WHERE OPNDAT = Today() and OPNDAT <= Today() - 120.

Hope this helps.

2 Replies
sinanozdemir
Valued Contributor III

Re: Date Filtering - Qilk Sense

Hi Barry,

You can try to handle this in your WHERE clause:

WHERE OPNDAT = Today() and OPNDAT <= Today() - 120.

Hope this helps.

Not applicable

Re: Date Filtering - Qilk Sense

That did it Thank you ...