set analysis in qlik sense

kulasekhar — Thu, 10 Dec 2015 14:10:58 GMT

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.

Re: set analysis in qlik sense

hemhund2016 — Thu, 10 Dec 2015 14:58:16 GMT

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

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.