Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kulasekhar
Creator
Creator

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
Creator
Creator

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
Creator
Creator

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