Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

How about this:

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

Not applicable
Author

Thanks Sunny it worked..

sunny_talwar

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