Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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

View solution in original post

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