Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ilya_Bobrov
Contributor III
Contributor III

Intervalmatch problem

Good day!
There is a problem using the intervalmatch function.
In short: Having executed the script below,
despite the fact that the correct values ​​are displayed in the Data manager,
when you try to use the sum () function in the visualization,
all values ​​increase exactly 4 times.
Please tell me what is wrong with the script?

Script:

TransactionTable:
load * inline [org,mindate,maxdate,Date1,val
'rome','2019-01-01','2019-01-30','2019-01-20',200
'rome','2019-01-01','2019-01-30','2019-01-30',200
'igi','2019-01-01','2019-01-20','2019-01-10',300
'igi','2019-01-01','2019-01-20','2019-01-15',300];
NoConcatenate
Tr:
load org,mindate,maxdate
resident TransactionTable;
drop table TransactionTable;

MinMaxDate:
Load Min(mindate) as MinDate, Max(maxdate) as MaxDate resident Tr;
Let vMinDate = Peek('MinDate',-1,'MinMaxDate');
Let vMaxDate = Peek('MaxDate',-1,'MinMaxDate')+1;
Drop Table MinMaxDate;

MasterCalendar:
Load Date($(vMinDate) + RecNo() -1) AS Date
Autogenerate vMaxDate-vMinDate;
inner join (Tr) intervalmatch (Date) LOAD mindate,maxdate
resident Tr;
drop table MasterCalendar;
NoConcatenate
result:
Load org&Date as Key,*
resident Tr;
drop table Tr;
left join
dat:
load org1&Date1 as Key,val1;
load * inline [org1,Date1,val1
'rome','1/20/2019',200
'rome','1/30/2019',200
'igi','1/10/2019',300
'igi','1/15/2019',300];

Labels (5)
1 Solution

Accepted Solutions
RicardodelaRosa
Contributor
Contributor

You need to add distinct in the load of tr because org, mindate and maxdate are duplicated on your TransactionTable.

View solution in original post

1 Reply
RicardodelaRosa
Contributor
Contributor

You need to add distinct in the load of tr because org, mindate and maxdate are duplicated on your TransactionTable.

View solution in original post