I'd like to display a summary page to sum up which component calls which globaly and wether there is at least one synchronous call between the two. :
component A calls ComponentB. (whatever the services called, etc...)
and put ComponentB in 'red' if it is a synchronous call.
The problem is that in my Fact table I have many lines with ComponentA calling ComponentB.
And I don't know how to tell QLik to use red if at least one has a 'synchronous' value in 'TypeOfCall'. It seems QLik uses the first value that it found on the Fact Table that matches A & B. So if the first call registered is asynchronous, it doesn't put the link between A & B in red...
There is no 'exists' function on the color expression... I tried if (exists(TypeOfCall, 'synchronous') but it is not reckognized.