Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

olguita2014
Contributor

Compare records from a field

Hi,

Please I need your help!!!!!

I want to compare records from a field.  For example:

122

123

1231

1232

1233

1234

In this example, the number 123 exists in the other registers, but 122 does not exist.

Thanks

2 Replies
aronwilliamson
Contributor

Re: Compare records from a field

Are you specifically looking for "123"? what are you trying to do e.g. trying to find all numbers starting 123...

olguita2014
Contributor

Re: Compare records from a field

Take the length of the number equal to 3, then compare that with all other records if there is a relationship.

1234

1235

1236

1237

122

The Answer:  123 yes it exists in the comparison but 122 no

Community Browser