exp

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

HI All ,

can someone explain this what is thi expression doing ? i have field (listbox) by nam iball within which there is only on string that is "perform"

basicall i need to show he number count for " perform" too like other brands hence i copied this expression from where i copied this it has 3 data in that ( there is a listbox called Department and whitin department there are finance, HR, Acnt) but for iball there is only one that is perform . thereofre i need to edit this expression accordingly

=concat(

{$<

Iball = ,

Hierarchy = P(Hierarchy_S)

} distinct

if (Aggr(

Count(DISTINCT

{$<

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

Iball = ,

Hierarchy = P(Hierarchy_S)

>} Lead_UID)

,Iball) >0,

Iball &'|'&

Num(

Aggr(

Count(DISTINCT

{$<

Iball = ,

Hierarchy = P(Hierarchy_S),

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

>} Lead_UID)

, Iball)

, '#,##0')

&'|'&

if(

Aggr(

Num(

Count(DISTINCT

{$<

Iball = ,

Hierarchy = P(Hierarchy_S)

>} Lead_UID)

, '#,##0')

, Iball) > 0, 1,0)

&'|'&

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

)

, ';')

topic exp in QlikView

exp