topic Getting Problem with Interval Match() Can any one Give a Proper Solution? in QlikView

Getting Problem with Interval Match() Can any one Give a Proper Solution?

sgg_gaikwad — Wed, 12 Feb 2014 12:07:20 GMT

Layout:

LOAD LineNum,

Type,

Description,

[GL Account Start] ,

[GL Account End] ,

[Total Start],

[Total End],

Sign

FROM

(ooxml, embedded labels, table is PAndL);

PLData:

LOAD //Period,

Date,

GLAccount,

Office,

Amount,

AccountType

//F7

FROM

(biff, embedded labels, table is [Data$]);

IntervalMatch(GLAccount)

LOAD

[GL Account Start] & [GL Account End] as GLStartEnd Resident Layout;

Re: Getting Problem with Interval Match() Can any one Give a Proper Solution?

MK_QSL — Wed, 12 Feb 2014 12:10:36 GMT

Change

IntervalMatch(GLAccount)

LOAD

[GL Account Start] & [GL Account End] as GLStartEnd Resident Layout;

Final:

IntervalMatch(Date) Left Join Load [GL Account Start] , [GL Account End] Resident Layout;

Left Join (PLData) Load * Resident Layout;

Drop Table Layout;

Re: Getting Problem with Interval Match() Can any one Give a Proper Solution?

manideep78 — Wed, 12 Feb 2014 12:13:22 GMT

Try This

IntervalMatch(Date)

LOAD

[GL Account Start] , [GL Account End] Resident Layout;

Re: Getting Problem with Interval Match() Can any one Give a Proper Solution?

sgg_gaikwad — Wed, 12 Feb 2014 12:26:44 GMT

Hi Manish,

Thanx for Reply Its working..

But,I don't want single table in Data Model I need Three Different table in Data Model...

Re: Getting Problem with Interval Match() Can any one Give a Proper Solution?

sgg_gaikwad — Wed, 12 Feb 2014 12:28:20 GMT

Hi Manideep,

It is creating a Synthetic key in Data Model & i need Three Separate table in Data Model..

Re: Getting Problem with Interval Match() Can any one Give a Proper Solution?

MK_QSL — Wed, 12 Feb 2014 12:30:34 GMT

Remove

Left Join (PLData) Load * Resident Layout;

Drop Table Layout;

add

Left Keep (PLData) Load * Resident Layout;