Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
vmonitor
Contributor III
Contributor III

Count the number of successful contexts that contain a specific code.

Here is an example context:

diroperatorCall IDcontextB_numbercode
Вход (не усп)O790320139108411260525556133606
Исх (не усп)PDGI/TO-SIP-SS4-INT790320140108411260525556133502
Исх (не усп)el/TO-SIP-SS4-INT790320146108411260525556133503
Вход (не усп)O798778645108411261925221195487
Исх (не усп)fon-PDGI/TO-SIP-SS4-INT798778646108411261925221195503
Исх (не усп)PDGI/TO-SIP-SS4-INT798778658108411261925221195503
Исх (не усп)anet/TO-SIP-SS4-INT798778663108411261925221195487

 

It is necessary to select only those contexts in which the unique B_number and the unique operator number is greater than 2. Calculate how many of these contexts contain a specific operator and are successful (ie dir =Исх (усп))



-----------------------------------------------------

my dimensions:

=Aggr(Count(Distinct operator)>2, context)and Aggr(Count(DistinctB_number)=1, context)

=operator

---------------------------------------------------

I can't write the expression!

Tried it like this but it is not correct:

if(Aggr(Count(Distinct operator)>=3, context)and Aggr(Count(DistinctB_number)=1, context)
,count(Aggr(Count({<dir={"Вход (усп)"}>}context), context)))

----------------------------------

I want to have such table.

operatorall callssuccessful  operator successful  contextcontext&503
atel3311200
irika289028
ELINE-PDGI19130
wer–PDGI141012
K-PDGI13121
S-PDGI9442
ukanet6220
T15001
lycomm-PDGI3200
mpelcom1000

 

0 Replies