Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Date filter for set analysis

Hi everyone

I need to do a set analysis  for all the records after 31st march 2016.I am using the following visualisation function but not getting any result can anyone help me with it

(count({$<Date={">3/31/2016"}>}distinct TransactionSlip))

The Date is uploaded with make date

3 Replies
MVP
MVP

Re: Date filter for set analysis

How about this:

Count({$<Date = {"$(='>' & Date(MakeDate(2016, 3, 31), 'M/D/YYYY'))"}>} DISTINCT TransactionSlip))

Not applicable

Re: Date filter for set analysis

Thanks Sunny it worked..

MVP
MVP

Re: Date filter for set analysis

Awesome -

I know you have marked the above response as helpful, but I would also suggest marking the correct response to close this thread so that others don't have to open this thread to realize that the issue has been resolved

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Community Browser