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: 
gerhardl
Creator II
Creator II

Selection does not match

Hi,

I get very confused with synthetic keys and loops and things. I pull data from three different tables:

1. Account extract

2. Transaction Extracts

3. Application Extracts

I load the Account Extract first and load 'Account no as 'Account No',

then I load a transaction extract (which has an Account No field) WHERE EXISTS 'Account No').

This works perfectly. But when I make selections on my sheets that shows transactions it will not match back to my application data (as my application extract has no account number yet).

There is a field that I can use to match back, which has the same data, but the field has different names for all three extracts!

Application Extract - Company Code

Transaction Extract - Company

Application Extract - Company No

I need to be able to select a Company and look at its account holders' transactions, and then also go to a different sheet and look at all its applications.

I also have a synthetic field called 'Appl No' and 'Appl no' in my Account and Application extracts but when I use the WHERE EXISTS'Appl No') I get an error saying there is a loop in my file!

Please help!

LOAD 'Account no' as 'Account no',

          if('Company Code'=ASA','Ackermans SA', if('Company Code'='ANA','Ackermans NAM', if('Company Code'='HTSA','Hang Ten SA', if('Company Code'='HTNA','Hang Ten NAM', if('Company Code'='JJSA','Jay Jays SA', if('Company Code'='JJNA','Jay Jays NAM', if('Company Code'='SCSA','Shoe City SA' , if('Company Code'='SCNA','Shoe City NAM')))))))) as 'Company Code',

         'Appl no',

FROM xxxxx

LOAD Company,

          Selection does not match,

FROM

...Transaction Extracts\*.txt

WHERE (Selection does not match=35 or Selection does not match=36 or Selection does not match=37 or Selection does not match=931) and (exists(Selection does not match));

LOAD if(Selection does not match='SCSA','Shoe City SA', if(Selection does not match='HTSA','Hang Ten SA', if(Selection does not match='ASA','Ackermans SA', if(Selection does not match='ANA','Ackermans NAM' )))) as Selection does not match,

Selection does not match,

FROM

Selection does not match

WHERE (Selection does not match>4);

2 Replies
Miguel_Angel_Baeyens

Hello,

I don't know if it's just me, but I see a lot of "Selection does not match" in your post instead of actual data. Are you using some code before fields?

Example (in bold):

I load the Account Extract first and load Selection does not match as Selection does not match,

then I load a transaction extract (which has an Account No field) WHERE EXISTS(Selection does not match).

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

gerhardl
Creator II
Creator II
Author

The new QlikView site is killing me. I cannot put any field names in or I get the Selection Does not match – whenever I use brackets.

Also, NONE of my links work, I cannot reply to posts or do anything – I can only reply directly to the email notification I get.

Is there someone I could email my script to or something…?

Regards,

Gerhard