Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

How to create a function to capture the same customers who are having more than one policies

Dear Members,

 

As per the sample data, there are some customers who have more than one policies. Their names are same but some times the name are the same but what is typed is with out the Mr or Miss. When we need to select customers who fall in to that category (more than one policies), how this is done in front end as well as back end?

 

Thanks

 

Neville

1 Solution

Accepted Solutions
Anil_Babu_Samineni

I apologies for not looking since long time on this. I've used this way of condition in list box

=If(Aggr(Count(NAME),NAME)>1, 'More than one', 'Only one')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies
nevilledhamsiri
Specialist
Specialist
Author

Can someone help me on this

Anil_Babu_Samineni

PFA

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nevilledhamsiri
Specialist
Specialist
Author

Dear Anil,

Could you please copy your script,formula in the body of the reply as I cannot open your attachment

Thanks

 

Anil_Babu_Samineni

I apologies for not looking since long time on this. I've used this way of condition in list box

=If(Aggr(Count(NAME),NAME)>1, 'More than one', 'Only one')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)