# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Contributor

## set analysis in qlik sense

Hi All,

Count(

{<\$>

+ 1<[Display Score]={\$(=If(

len(GetFieldSelections(Score))>1,

(chr(39) & Concat(DISTINCT Score, chr(39) & ',' & Chr(39) ) & chr(39))

,Score))}>

(chr(39) & Concat(DISTINCT LeadScore, chr(39) & ',' & Chr(39) ) & chr(39))

}

[Company Name] )

Thanks

sekhar.

1 Solution

Accepted Solutions
Contributor

## Re: set analysis in qlik sense

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

Thanks,

hemanth.

Contributor

## Re: set analysis in qlik sense

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