Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

to show the common values

Hi Folks, i have a Question, does anybody knows how to Show the common values between the rows by creating of new column, 

my example does look like:

Project, Values

A,  5, 10, 15

B, 2, 10, 5

C, 4, 9, 15

D, 5, 10, 9

 

my expected Output does look like:

Project, Values, The Common Values as (new column)

A,  5, 9, 15

B, 5, 10, 15, between B and A we have: 5 , 15

C, 4, 9, 15,  between C and B we have: 15

D, 5, 10, 9,  between D and B we have: 9

Does anybody have any idea how to resolve this issue?

Thanks  a lot in advance

Beck

 

Labels (1)
0 Replies