Expression

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

Can someone explain me what this below expression is doing ?

=concat(

{$<

Lead = ,

Hierarchy = P(Hierarchy_S)

} distinct

if (Aggr(

Count(DISTINCT

{$<

Date={">=$(StartDate)<=$(EndDate)"},

Lead = ,

Hierarchy = P(Hierarchy_S)

>} Lead_UID)

,Lead) >0,

Lead &'|'&

Num(

Aggr(

Count(DISTINCT

{$<

Lead = ,

Hierarchy = P(Hierarchy_S),

Date={">=$(StartDate)<=$(EndDate)"}

>} Lead_UID)

, Lead)

, '#,##0')

&'|'&

if(wildmatch(GetFieldSelections(Lead),'*'&Lead&'*')>0, 1, 0)

)

, ';')

topic Expression in QlikView