Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

please suggest

Hi

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

   

ServerTimestampStatus
A3/19/2015 17:29DOWN
A3/9/2015 14:09Maitenance
B3/2/2015 14:09Intransit
C7/29/2015 1:29DOWN

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Like this?

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

9 Replies
gautik92
Specialist III
Specialist III

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

sunny_talwar

Try this:

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

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi Try THis:

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

Not applicable
Author

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.

Not applicable
Author

=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

sunny_talwar

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))

jonathandienst
Partner - Champion III
Partner - Champion III

Like this?

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
shair_abbas
Partner - Creator
Partner - Creator

hope it will work if you want to show only count

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

Not applicable
Author

Thanks Jonathan, It worked