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: 
soniasweety
Master
Master

matching data

Hi all,

franky_h79

Andrey Krylov

i want to highlight the ID's

Which ever ID not there in SOurceB should be highlted with red colur -   [it should compare with sourceA-Bcz sourceA will contain all the data]

which ID is not matching with SOurce A and SourceB   in  yellow

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

check attached.

red for ID only in SourceA

blue for ID only in SourceB

yellow for ID present in both

View solution in original post

8 Replies
Frank_Hartmann
Master II
Master II

maybe like attached.

hope this helps

soniasweety
Master
Master
Author

thank you..

1.can i get the count same  for colurs ?in text objects ?    [red count and yellow count?]

2.i want to hide the measure ? is there anyway to show only dimension columns? bcz i dont have any measure column in data...!

how can i achieve this?

andrey_krylov
Specialist
Specialist

Sony, I've highlighted the IDs not presented in both sources at the same time. Did not quite understand what was needed to highlight yellow and what red

Frank_Hartmann
Master II
Master II

see attached

soniasweety
Master
Master
Author

thank you looks ok.. but i have seen a case today morning..  in sourceB  one ID present and not in SOurceA  that should show as some other colour..

i m checking that id.  let me know if you can find that

Frank_Hartmann
Master II
Master II

check attached.

red for ID only in SourceA

blue for ID only in SourceB

yellow for ID present in both

soniasweety
Master
Master
Author

Hi andrey.krylov  in your attached qvw how can i get the  red colur count and yellow color count?

andrey_krylov
Specialist
Specialist

I think like this