Issue Migrating IntervalMatch from QlikView to Qlik Sense – Only Field Names, No Data Returned

[MarioGabriel]

Hello,

I'm currently in the process of migrating an existing QlikView application to Qlik Sense. One part of the script involves using IntervalMatch() to map account numbers to predefined level 3 ranges for account grouping.

However, after the migration, I’m facing an issue where Qlik Sense only returns the field names, but no actual data is shown in the resulting table (even though the script executes without error).

What I’ve done:

• Recreated the exact logic from QlikView using the same QVD files.

• Verified the data is present by previewing the individual source tables (accounts, intervals).

• Tried both INNER JOIN and LEFT JOIN around IntervalMatch() but the result is the same – no rows.

What seems strange:

• The exact same script with IntervalMatch works in QlikView, but fails silently in Qlik Sense.

• It appears to load structure (columns) but no content.

Has anyone experienced similar behavior with IntervalMatch() after migrating to Qlik Sense? Are there best practices or known differences I should be aware of?

I’ll attach a simplified part of the script to clarify.

Sub Formulate_Account_Grouping

/*

Actually we want to group accounts by 4 levels or categories

starting from level 3

*/

/*

these are the accounts that we want per company

*/

account_level:

LOAD distinct 

GMAID as account_row_id,

GMCO as company_id,

GMOBJ as account_num

FROM

[lib://QVD/Tables/PRODDTA.F0901.qvd]

(qvd)

where  GMCO <> 99999

and wildmatch(GMLDA ,6,7,8)

and (GMPEC <> 'N' or GMOBJ=4999);

//and GMPEC <> 'N';

/*************************************************************************************************/

/*

let's formulate the starting level which is level 3

*/

temp_acc_level_3:

LOAD distinct 

GMCO as company_id,

GMOBJ as acc_num_3,

GMDL01 as acc_level_3

from [lib://QVD /Tables/PRODDTA.F0901.qvd]

(qvd)

where  

GMCO <> 99999

and  GMLDA = 3

and GMPEC = 'N';

temp_acc_level_3_2:

NoConcatenate

LOAD * Resident temp_acc_level_3

Order by company_id asc,acc_num_3 desc;

drop Table temp_acc_level_3;

temp_acc_level_3_3:

LOAD 

        company_id,

acc_level_3,

acc_num_3, 

acc_num_3 as start_account,

if(RowNo() = 1 or company_id <> Previous(company_id),99999,Peek(start_account) -1 ) as end_account

Resident temp_acc_level_3_2;

drop Table temp_acc_level_3_2;

temp_match:

IntervalMatch(account_num) 

    LOAD start_account,end_account

Resident temp_acc_level_3_3;

INNER JOIN(account_level)

LOAD * Resident temp_match;

drop Table temp_match;

INNER JOIN(account_level)

LOAD start_account,end_account, acc_level_3,company_id,acc_num_3

Resident temp_acc_level_3_3;

drop Table temp_acc_level_3_3;

drop fields start_account,end_account;

Would greatly appreciate your input. Thanks!

[-SW-]

I have encountered similar problems before and in my case it was how Qlik Sense was referring my fields as text as opposed to numbers. Can you try and force all relevant fields with Num() and try again?

[MarioGabriel]

Thank you for your reply, but I have already tried it and still didn’t work.

[Mark_Little]

I have not seen an issue with the interval match it should work the same (And has for me).

I have seen different behaviour on the Peek or Previous (Previous I believe, sorry can't remember).

I would check this table is getting created as expected

temp_acc_level_3_3:

LOAD 

        company_id,

acc_level_3,

acc_num_3, 

acc_num_3 as start_account,

if(RowNo() = 1 or company_id <> Previous(company_id),99999,Peek(start_account) -1 ) as end_account

Resident temp_acc_level_3_2;

drop Table temp_acc_level_3_2;

Mark

[rafaelencinas]

Reading your code:

1 - Order by your code here:

temp_acc_level_3_3:
LOAD
company_id,
acc_level_3,
acc_num_3,
acc_num_3 as start_account,
if(RowNo() = 1 or company_id <> Previous(company_id),99999,Peek(start_account) -1 ) as end_account
Resident temp_acc_level_3_2

Order by company_id , acc_num_3 

;

2 - Reload all tables, checking DataTypes of each field to avoid mistakes with math operations in Where Clause

Bye!

[MarioGabriel]

Hi Mark,

Thank you for your reply. The issue lies with this table: as you can see, the table is returning zeros. I have tried nearly everything, but I still am not getting any data.

[-SW-]

can you show some example values of

account_num in one table and

start_account,end_account

in another table?

[MarioGabriel]

Hello. Here are the two tables: the start_account column is interpreted as text (tagged $ascii $text), while end_account is numeric but displays many “–” entries (nulls).

[MarioGabriel]

Thank you Rafael for the suggestion. I did add the ORDER BY company_id, acc_num_3 clause to the resident load exactly as you showed, but the end_account values are still not lining up the way I expect. I also reloaded everything and verified that company_id and acc_num_3 are numeric, so the sort should work but it isn’t.

[-SW-]

can you try adding CompanyID to the intervalmatch?

temp_match:

IntervalMatch(account_num,company_id) 

    LOAD start_account,end_account,company_id

Resident temp_acc_level_3_3;