Discussion Board for collaboration related to QlikView App Development.
Hi All,
please explain below expression.
Count(
{<$>
+ 1<[Display Score]={$(=If(
len(GetFieldSelections(Score))>1,
(chr(39) & Concat(DISTINCT Score, chr(39) & ',' & Chr(39) ) & chr(39))
,Score))}>
+ 1<[Overall Lead Score]={$(=If(
len(GetFieldSelections(LeadScore))>1,
(chr(39) & Concat(DISTINCT LeadScore, chr(39) & ',' & Chr(39) ) & chr(39))
,LeadScore))}>
}
[Company Name] )
Thanks
sekhar.
Hi Sekhar,
This is what the expression doing.
It is calculating the count of Comany names with below condidtions
if there are any field selections on Score field, it is concatenating the distinct score values single quotes and comma
else it is taking score
if there are any field selections on LeadScorefield, it is concatenating the distinct LeadScorevalues single quotes and comma
else it is taking LeadScore
Let me know if it answers your question.
Thanks,
hemanth.
Hi Sekhar,
This is what the expression doing.
It is calculating the count of Comany names with below condidtions
if there are any field selections on Score field, it is concatenating the distinct score values single quotes and comma
else it is taking score
if there are any field selections on LeadScorefield, it is concatenating the distinct LeadScorevalues single quotes and comma
else it is taking LeadScore
Let me know if it answers your question.
Thanks,
hemanth.