Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
lornafnb
Valued Contributor

Where Exists

hi guys

PFA

The Not Exists in this model doesnt work.....I dont understand why

(Do I need to use 'CAST" as character in the native SQL code, as QV takes everything to text?)

Thanks

10 Replies
YoussefBelloum
Esteemed Contributor

Re: Where Exists

Hi,

are you sure that seq_no coming from totus_ra.ra_bts_susp_cookie_log_v3  have the exact same values than report_ID coming from totus_ra.ra_bts_onlinebankingflaggedprofiles ?

did you make separate extract ?

lornafnb
Valued Contributor

Re: Where Exists

have a look at the attached !

YoussefBelloum
Esteemed Contributor

Re: Where Exists

I looked both versions.. did you see that the key field values coming from your tables are different ?

lornafnb
Valued Contributor

Re: Where Exists

Hi yes I did. I have no idea what I am doing wrong

Sent from my Samsung Galaxy smartphone.

YoussefBelloum
Esteemed Contributor

Re: Where Exists

you have approximatively 5% of distinct values (in the ra_bts_onlinebankingflaggedprofiles table) found on the other table..

Creating homonyms (via aliases) is not enough to create keys. here you should verify again the joining Key, because even with transformations you will not be able to link your table with that field coming from ra_bts_onlinebankingflaggedprofiles

kotaajaykumar
New Contributor

Re: Where Exists

lornafnb
Valued Contributor

Re: Where Exists

Ok so in effect you saying I should verify the data types of the joining field?

I'm not too concerned about the 5 % ratio... That is realistic

Sent from my Samsung Galaxy smartphone.

YoussefBelloum
Esteemed Contributor

Re: Where Exists

I'm saying that you should verify the way you're trying to Link/connect/join these two tables, verify that you're using the correct Key fields.

In fact, you're very concerned by that ratio, it shows how good/poor the quality of your key is

lornafnb
Valued Contributor

Re: Where Exists

hI Youssef,

I've decided to this via APPLYMAP - its easy and quick.

Thank you so much for your help.

Lorna

Community Browser