topic Re: matching data in QlikView

matching data

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

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

Re: matching data

Frank_Hartmann — Wed, 31 Oct 2018 10:31:08 GMT

maybe like attached.

hope this helps

Re: matching data

soniasweety — Wed, 31 Oct 2018 10:36:28 GMT

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?

Re: matching data

andrey_krylov — Wed, 31 Oct 2018 10:39:35 GMT

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

Re: matching data

Frank_Hartmann — Wed, 31 Oct 2018 10:42:07 GMT

see attached

Re: matching data

soniasweety — Wed, 31 Oct 2018 10:55:39 GMT

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

Re: matching data

Frank_Hartmann — Wed, 31 Oct 2018 11:04:57 GMT

check attached.

red for ID only in SourceA

blue for ID only in SourceB

yellow for ID present in both

Re: matching data

soniasweety — Wed, 31 Oct 2018 13:24:28 GMT

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

Re: matching data

andrey_krylov — Wed, 31 Oct 2018 14:21:33 GMT

I think like this