topic Re: please suggest in QlikView

please suggest

Mon, 28 Sep 2015 11:37:36 GMT

i need to show the count of the devices whose status is DOWN

Server	Timestamp	Status
A	3/19/2015 17:29	DOWN
A	3/9/2015 14:09	Maitenance
B	3/2/2015 14:09	Intransit
C	7/29/2015 1:29	DOWN

So according to the above table the device count count should be 2 but i have to ignore the DOWN status of Server is the server has atleast one more record as Maintenance so going by this Server A should not be considered as DOWN and should get only Server C as down

Re: please suggest

gautik92 — Mon, 28 Sep 2015 11:40:26 GMT

count({<Status={'DOWN'}>}Server)

Re: please suggest

sunny_talwar — Mon, 28 Sep 2015 11:51:48 GMT

Try this:

=Sum(Aggr(If(Count({<Status = {'DOWN'}>} Status) = Count(Status), 0, 1), Server))

Re: please suggest

nagarjuna_kotha — Mon, 28 Sep 2015 11:54:29 GMT

Hi Try THis:

=count({<Status={'DOWN'}>}Server)

Re: please suggest

Mon, 28 Sep 2015 12:23:46 GMT

I want to show only Server C as this has only DOWN Status but Server A should not fit in the requirement as if a Server has a Maintenance Status as well as DOWN Status so that particular Server should not be considered as DOWN.

Re: please suggest

Mon, 28 Sep 2015 12:26:31 GMT

=count({<Status={'DOWN'}>}Server)

this will use set analysis to only count the items (server) that have a value of 'DOWN' in the Status field

Re: please suggest

sunny_talwar — Mon, 28 Sep 2015 12:28:38 GMT

If you want to show only C as down, try this:

=Sum(Aggr(If(Count({<Status = {'DOWN'}>} Status) = Count(Status), 1, 0), Server))

and to see which one was down, try this:

=Concat(Aggr(If(Count({<Status = {'DOWN'}>} Status) = Count(Status), Server), Server))

Re: please suggest

jonathandienst — Mon, 28 Sep 2015 12:35:33 GMT

Like this?

count({<Status={'DOWN'}, Server = E({<Status = {'Maintenance'}>} Server)>} Server)

Re: please suggest

shair_abbas — Mon, 28 Sep 2015 12:55:05 GMT

hope it will work if you want to show only count

count({<status={'DOWN'}>}server) - count({<status={'Maintenance'}>}server)

Re: please suggest

Tue, 29 Sep 2015 09:05:53 GMT

Thanks Jonathan, It worked