topic Re. :AW:Re. :AW:HELP in a qlikview statement in QlikView

HELP in a qlikview statement

Wed, 27 Apr 2011 12:08:16 GMT

Hi.

I have two tables TABLE1 and TABLE2 as presented in the attached file.

I want to write a qlikview script to construct the TABLE3 always as presented in the attached file.

NB:

Look at the semantic between the fields DEBCPTE and FINCPTE of table FORMULE and field NUMCPT of table ECRITURE.

The field IDFORMULE of the table FORMULE must migrate into the newer created table.

Thanks.

AW:HELP in a qlikview statement

brenner_martina — Wed, 27 Apr 2011 12:11:01 GMT

??? where is the file ????

AW:HELP in a qlikview statement

brenner_martina — Wed, 27 Apr 2011 12:15:42 GMT

Hi Gael,

pardon, what has to match together?

DEBCPTE & FINCPTE with a part of NUMCPT?

or do you mean intervalmatch?

Re. :AW:HELP in a qlikview statement

Wed, 27 Apr 2011 12:24:44 GMT


Martina wrote:
Hi Gael,
pardon, what has to match together?
DEBCPTE & FINCPTE with a part of NUMCPT?
or do you mean intervalmatch?<div></div>

Yes DEBCPTE and FINCPTE are the bounds of interval and also the part of NUMCPT.

AW:Re. :AW:HELP in a qlikview statement

brenner_martina — Wed, 27 Apr 2011 12:27:26 GMT

OK, so you have to seperat the first to numbers of NUMCPT:

Left(NUMCPT,2) As NUMCPTKey

then use the function intervalmatch from your first table with start DEBCPTE and End FINCPTE

Re. :AW:Re. :AW:HELP in a qlikview statement

Wed, 27 Apr 2011 12:59:40 GMT


Martina wrote:
OK, so you have to seperat the first to numbers of NUMCPT:
Left(NUMCPT,2) As NUMCPTKey
then use the function intervalmatch from your first table with start DEBCPTE and End FINCPTE<div></div>

Please Martina, can you do an example?

Please look at the attached file.

Thanks.

Re. :AW:Re. :AW:HELP in a qlikview statement

Wed, 27 Apr 2011 13:59:37 GMT

PFA.

Re. :AW:Re. :AW:HELP in a qlikview statement

Wed, 27 Apr 2011 14:13:36 GMT

Please Srinivasan.

Have you looked at the structure of TABLE3 in the attached file LIST_OF_TABLE.doc?
I can not find the field IDFORMULE, yet it is most important.
Thank you.