topic Re: Set Analysis Help in QlikView

Set Analysis Help

Sat, 05 Apr 2014 23:54:37 GMT

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 :

Seeking Answer for the above should be - 3

swuehl — Sun, 06 Apr 2014 00:14:11 GMT

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)

Sun, 06 Apr 2014 00:25:33 GMT

Hi Swehl,

Thanks for the Quick Reply.

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

Sun, 06 Apr 2014 00:27:32 GMT

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

swuehl — Sun, 06 Apr 2014 00:31:22 GMT

Please read this blog:

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

Sun, 06 Apr 2014 00:32:33 GMT

Thanks Swehl. It works.