Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gerhardl
Contributor 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);

Tags (3)
2 Replies

Re: Selection does not match

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
Contributor II

Re: Selection does not match

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