Set Analysis Help

[#1]

Hi Community users,

I need some help on the set analysis.

I want to display Count of Vessels , who are using 80% of space in last one day.

Fields i have are :

VesselName	SpaceUtilize%	Date
AXU	95	06-Apr-2014
AYU	69	06-Apr-2014
BUY	80	06-Apr-2014
CZE	90	05-Apr-2014
ZCE	81	06-Apr-2014
AXY	67	06-Apr-2014

Seeking Answer for the above should be - 3

[swuehl]

Date should be a dual value, i.e. interpreted correctly as date, then try

=count({<[SpaceUtilite%] = {">=80"}, Date = {'$(=Date(max(Date),'DD-MMM-YYYY'))'}>} DISTINCT VesselName)

[#3]

Hi Swehl,

Thanks for the Quick Reply.

date parameter is not working here. without date it is working fine.

[#4]

I want to reflect the data of Yesterday or last 24 hours

[swuehl · Accepted solution]

Please read this blog:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work

=count({<[SpaceUtilite%] = {">=80"}, Date = {">=$(=Date(today()-1,'DD-MMM-YYYY'))"}>} DISTINCT VesselName)

[#6]

Thanks Swehl. It works.