matching data

[soniasweety]

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

[Frank_Hartmann]

maybe like attached.

hope this helps

[soniasweety]

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]

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]

see attached

[soniasweety]

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 · Accepted solution]

check attached.

red for ID only in SourceA

blue for ID only in SourceB

yellow for ID present in both

[soniasweety]

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

[andrey_krylov]

I think like this