Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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