Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
nevilledhamsiri
Valued Contributor

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

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

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')

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
Highlighted
nevilledhamsiri
Valued Contributor

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

Can someone help me on this

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

PFA

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

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

Dear Anil,

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

Thanks

 

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

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')

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