Qlik Community

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
kulasekhar
Contributor

set analysis in qlik sense

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.

1 Solution

Accepted Solutions
hemhund2016
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

              else it is taking LeadScore

Let me know if it answers your question.

Thanks,

hemanth.

View solution in original post

1 Reply
hemhund2016
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

              else it is taking LeadScore

Let me know if it answers your question.

Thanks,

hemanth.

View solution in original post