topic Re: IntervalMatch with 2 intervals in QlikView

IntervalMatch with 2 intervals

Wed, 29 Mar 2017 14:23:58 GMT

Hello

I am having problems using the intervalmatch with 2 intervals and SAP. I have explorered the IntervalMatch (Extended Syntax) but it does not allow to intervals

[Facts]:

Load

[RACCT] as [Conta],

[KOSTL] as [CCusto],

[KSL] as [Value],

FROM

[..\..\DATOS\QVDATA\File.QVD] (qvd)

and i have a excel sheet that has the grouping configurations

[Config]:

LOAD * INLINE [

Grupo1, Grupo2, AccountFrom, AccountTo, CostCenterFrom, CostCenterTo,

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62100000, 62109999, 1101, 1189

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62111000, 62111999, 1101, 1189

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62211000, 62215999, 1101, 1189

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62216000, 62217999, 1101, 1189

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62221000, 62999999, 1101, 1189

Fabricacion Especialidades Tot, Fabricacion Especialidades, 64210000, 65128999, 1101, 1189

Fabricacion Especialidades Tot, Fabricacion Especialidades, 68200000, 69999999, 1101, 1189

Fabricacion Especialidades Tot, Fabricacion Especialidades, 73120000, 73120000, 1101, 1189

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62100000, 62109999, 9800, 9800

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62111000, 62111999, 9800, 9800

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62211000, 62215999, 9800, 9800

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62216000, 62217999, 9800, 9800

Fabricacion Especialidades Tot, Fabricacion Especialidades, 62221000, 62999999, 9800, 9800

Fabricacion Especialidades Tot, Fabricacion Especialidades, 64210000, 65128999, 9800, 9800

Fabricacion Especialidades Tot, Fabricacion Especialidades, 68200000, 69999999, 9800, 9800

Fabricacion Especialidades Tot, Fabricacion Especialidades, 73120000, 73120000, 9800, 9800

Fabricacion Especialidades Tot, Costes Personal, 63111000, 63699999, 1101, 1189

];

I need to get the value of Grupo1, Grupo2 when ever field [Conta] is between AccountFrom and AccountTo and field [CCusto] is between CostCenterFrom and CostCenterTo

Re: IntervalMatch with 2 intervals

Kushal_Chawda — Wed, 29 Mar 2017 17:37:12 GMT

try like below

Group_Map:

MAPPING LOAD

AccountFrom+(iterNo()-1) as Key,

Grupo1&'-'&Grupo2 as Group

From ConfigFile

WHILE iterNo() <= (AccountTo - AccountFrom) + 1;

[Facts]:

Load

[RACCT] as [Conta],

subfield(applyMap('Group_Map', [Conta], 'Other'),'-',1) as Group1,

subfield(applyMap('Group_Map', [Conta], 'Other'),'-',2) as Group2,

[KOSTL] as [CCusto],

[KSL] as [Value],

FROM

[..\..\DATOS\QVDATA\File.QVD] (qvd)

Re: IntervalMatch with 2 intervals

Thu, 30 Mar 2017 09:26:58 GMT

Thank you for your reply

That solution only takes in consideration 1 of values Conta but i still need the Ccusto field

Re: IntervalMatch with 2 intervals

swuehl — Thu, 30 Mar 2017 11:00:43 GMT

You should be able to use something like this (there might be better solutions though):

[Facts]:

Load

[RACCT] as [Conta],

[KOSTL] as [CCusto],

[KSL] as [Value]

INLINE [

RACCT, KOSTL, KSL

62109888, 1150, 100

73120000, 1102, 200

63111002, 1180, 300

];

[Config]:

LOAD *, Recno() as ConfigID INLINE [