Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
iczkla
Contributor III
Contributor III

Track changes within 3 columns

Hello,

I have a table in which there are  columns ID, Compensation Change, Job Title Change and Location Change.

In each column value is either yes or no, so it looks something like that:

ID | Compensation Change | Job Title Change | Location Change

1   | Yes                                         | Yes                              | No

2   | No                                          | No                               | No

3   | Yes                                         | Yes                              | Yes

 

I want to track changes not separately but together - so irregardless if ID had 1 or 3 changes this should be treated as 1, so result should look something like this:

 

ID | Compensation Change | Job Title Change | Location Change | CHANGE?

1   | Yes                                         | Yes                              | No                             | Yes

2   | No                                          | No                               | No                             | No

3   | Yes                                         | Yes                              | Yes                            | Yes

 

I am assuming that I need to include some set analysis into my script but I am not sure how to do this.

Any help would be much appreciated. Thank you!

1 Solution

Accepted Solutions
Taoufiq_Zarra

@iczkla  Maye be like :

in dimension : ID | Compensation Change | Job Title Change | Location Change 

measure:

=if(wildmatch([Compensation Change]&[Job Title Change]&[Location Change],'*YES*')>0,'YES','NO')

 

output:

Taoufiq_Zarra_0-1628091257878.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

6 Replies
Taoufiq_Zarra

@iczkla  can you elaborate ?

how you get Yes for exemple in change for the first row and the second ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
iczkla
Contributor III
Contributor III
Author

Hi Taoufiq,

This is just how my data looks like - my goal is to create 5th column which will  show if there was a change in the row, regardless of the number of changes. So if 1 or more changes result will be Yes, and if 0 changes result will be No.

Taoufiq_Zarra

yes, but why Yes for ID 3 and Yes for the TD 1 ?

ID | Compensation Change | Job Title Change | Location Change | CHANGE?

1 | Yes | Yes | No | Yes

2 | No | No | No | No

3 | Yes | Yes | Yes | Yes

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
iczkla
Contributor III
Contributor III
Author

If there's at least one change in a row then Change column show Yes value, in ID 1 we have 2 Yes', condition =>1 Yes has been met, and in ID3 we have 3 Yes' so condition =>1 Yes has beet met as well.

I am sorry I am not able to explain more my logic ;<

Taoufiq_Zarra

@iczkla  Maye be like :

in dimension : ID | Compensation Change | Job Title Change | Location Change 

measure:

=if(wildmatch([Compensation Change]&[Job Title Change]&[Location Change],'*YES*')>0,'YES','NO')

 

output:

Taoufiq_Zarra_0-1628091257878.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
iczkla
Contributor III
Contributor III
Author

It works!!! Thank you so much for the help!