set analysis in qlik sense

[kulasekhar]

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.

[hemhund2016 · Accepted solution]

Hi Sekhar,

This is what the expression doing.

It is calculating the count of Comany names with below condidtions

• <$> means taking the current selections into consideration
• +  means it is union of new set with below condition to take only the values that matching with [Display Score]

               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

• same like above to take only the values that matching with [Overall LeadScore]

               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.