Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Unable to filter by Date

Hi,

I am trying to filter data by specific date. However, it ends up showing full set despite of $ in the front.

I tried many different ways:

SUM({$<[DATE(TRANSACTION_DATE,'MM/DD/YYYY')]=[DATE(TODAY(1),'MM/DD/YYYY')]>} QUANTITY)

SUM({$<[INDAY(DATE(TRANSACTION_DATE,'MM/DD/YYYY'),DATE(TODAY(1),'MM/DD/YYYY'),0)]>} QUANTITY)

It ends up showing full set unless I use Date filter.

Please help.

Thanks.

1 Solution

Accepted Solutions
MVP
MVP

Re: Unable to filter by Date

sum({$ <TRANSACTION_DATE={"$(=Today())"}>} QUANTITY)

o r

sum({$ <TRANSACTION_DATE={"$(=date(Today(),'MM/DD/YYYY'))"}>} QUANTITY)

the format of the 2 dates should be the same

2 Replies
MVP
MVP

Re: Unable to filter by Date

sum({$ <TRANSACTION_DATE={"$(=Today())"}>} QUANTITY)

o r

sum({$ <TRANSACTION_DATE={"$(=date(Today(),'MM/DD/YYYY'))"}>} QUANTITY)

the format of the 2 dates should be the same

Not applicable

Re: Unable to filter by Date

That works. Thank you.