Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajakumaranakash
Contributor II
Contributor II

Identifying Missing server details

I have a table with location and server information. I want to identify the missing server between the site.

 

My data:

Location Server
Site A Server1
Site A Server2
Site A Server3
Site A Server7
Site A Server5
Site B Server1
Site B Server2
Site B Server3
Site B Server4
Site B Server5
Site B Server6
Site B server8

 

Expected output: 

Location Missing Servers
Site A Server7
Site B Server6
Site B server8

 

Could some one help me on this?

 

Labels (1)
3 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

With this code I can get the good result

Data:
Load
  *
Inline [
Location,	Server
Site A,	Server1
Site A,	Server2
Site A,	Server3
Site A,	Server7
Site A,	Server5
Site B,	Server1
Site B,	Server2
Site B,	Server3
Site B,	Server4
Site B,	Server5
Site B,	Server6
Site B,	server8
];

Join(Data)
Load
  Location as Location2,
  Server
Resident Data
;

Load
  Location,
  Server
Where
  flag
;
Load
  count(Location2) <> FieldValueCount('Location') as flag,
  Location,
  Server
Resident Data
Group By
  Location,
  Server
;

Drop Table Data;

 

Help users find answers! Don't forget to mark a solution that worked for you!
Rajakumaranakash
Contributor II
Contributor II
Author

Thank you but I could not modify my script. So I would like to do this with expression. Is there any possible way?

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Okay 🙂

 

You can try a expression like this:

Count(total<Server> Server) = Count(distinct Location)

Aurelien_Martinez_0-1693495814401.png

 

 

Help users find answers! Don't forget to mark a solution that worked for you!