GL account and INTERVALMATCH question

amien — Thu, 09 Jun 2011 21:04:34 GMT

interval:

LOAD * INLINE [

GL_text , GL_from , GL_to

first , 10000, 20000

second , 20000, 30000

third , 40000, 50000

];

Is use this function to put all GL accounts in a certain category (GL_text).. works great ..

but for some reports i need this function too, but with an extra dimension.

Each GL account has a code .. and based on that code, the need need to be in a certain category (GL_text)

and its mixed .. for some GL accounts the code is not taken into consideration .. but for others it is .. so its mixed.

So, i have this table

GL_account , code

20000 , X1

20000 , X2

GL account 20000 and X1 should have a GL_text of 'forth'

and GL account 20000 and X2 should have a GL_text of 'fifth'

How can i solve this?

stephencredmond — Fri, 10 Jun 2011 22:49:02 GMT

Hi Amien,

Do you know that IntervalMatch can accept additional "keyfield" parameters (look for "IntervalMatch (Extended Syntax)" in the help file.

That might work for you?

Regards,

Stephen

topic GL account and INTERVALMATCH question in QlikView