Help with an accounting app.

Wed, 15 Oct 2014 14:57:47 GMT

Hi everybody.

I´m modyfing a part of an accounting app in where i have a lots of liability accounts. They can be current or non current.

The problem is that the app shows all the accounts as current.

All the liablity accounts are shown as current in a pivot table, what i have to do is "open" the accounts (they are 6) who have more than 12 months and put 12 months like current on that account, and the remaining months like non current in the same account

I´ve been trying a few hours but i don´t figure out what i have to do, at least in what i should begin to look.

I have a photo of the pivot table, the dimension used in the pivot table, and the expresion.

Sory but is in spanish, if you don´t understand i can translate the words.

Here is the load of the fields who are used in the dimension

LOAD
	CUENTA,
	//GRUPO 1
	LEFT(CUENTA,1) AS GRUPOID_1,
	lookup('CUEN_NOMBRE', 'CUENTA_AUX',LEFT(CUENTA,1), 'CUENTAS_TMP') AS GRUPO_NOMBRE_1,
	//GRUPO 2
	LEFT(CUENTA,2) AS GRUPOID_2,
	IF(LEN(CUENTA)>2,lookup('CUEN_NOMBRE', 'CUENTA_AUX',LEFT(CUENTA,2), 'CUENTAS_TMP')) AS GRUPO_NOMBRE_2,
	//GRUPO 3
	LEFT(CUENTA,4) AS GRUPOID_3,
	IF(LEN(CUENTA)>3, lookup('CUEN_NOMBRE', 'CUENTA_AUX',LEFT(CUENTA,4), 'CUENTAS_TMP')) AS GRUPO_NOMBRE_3,
	//GRUPO 4
	LEFT(CUENTA,6) AS GRUPOID_4,
	IF(LEN(CUENTA)>=4, lookup('CUEN_NOMBRE', 'CUENTA_AUX',LEFT(CUENTA,6), 'CUENTAS_TMP')) AS GRUPO_NOMBRE_4

Resident CUENTAS_TMP

WHERE CUEN_IMPUTABLE=1 AND

MATCH (LEFT(CUENTA,1),'1','2','3')>0;

This is used in the dimensions. with this you can divide the accounts in categories

Ej :

=IF(ISNULL(GRUPO_NOMBRE_1),'PATRIMONIO NETO', GRUPO_NOMBRE_1) etc...

And here i think is the sum of the money

TMP_SALDOSINICIALES:

FOR i = 1 TO $(vTotal)

load

EMPRESA,

DIVISION_A,

CUENTA,

// MAESTRO,

INSTANCIA,

SALDO AS SALDOINICIAL,

// AÑOMESCONTINUO AS AÑOMESCONTINUOORIGEN,

(AÑOMESCONTINUO + $(i)) as AÑOMESCONTINUO

RESIDENT TMP2;

NEXT i;

DROP TABLE TMP2;

SDOSINICIALES:

LOAD

EMPRESA,

DIVISION_A,

CUENTA,

// MAESTRO,

INSTANCIA,

AÑOMESCONTINUO,

SUM(SALDOINICIAL) AS SALDOSINICIALES

RESIDENT TMP_SALDOSINICIALES

GROUP BY

EMPRESA, //CHEQUEAR

DIVISION_A,

CUENTA,

// MAESTRO,

INSTANCIA,

AÑOMESCONTINUO;

topic Help with an accounting app. in QlikView

Help with an accounting app.