Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QS Community
i have a problem with... im not sure if is the expression itself, im using this expression to make an order list for a concepts in my app:
If(ConceptoCXC = 'CLIENTES', 1,
If(Conceptofbl3n = 'ALMACEN DE REFACCIONES', 2,
If(ConceptoCXC = 'OTRAS CUENTAS POR COBRAR FILIALES', 3,
If(ConceptoCXP = 'ANTICIPOS A PROVEEDORES', 4,
If(ConceptoCXP = 'ANTICIPOS A INTERCOMPAÑIAS', 5,
If(ConceptoCXP = 'FUNCIONARIOS Y EMPLEADOS', 6,
If(ConceptoCXP = 'DEPOSITOS EN GARANTIA', 7,
If(Conceptofbl3n = 'INVERSIONES EN FILIALES', 8,
If(Conceptofbl3n = 'MAQUINARIA Y EQUIPO DE OPERACIÓN', 9,
If(Conceptofbl3n = 'OTROS ACTIVOS FIJOS', 10,
If(Conceptofbl3n = 'GASTOS ANTICIPADOS ', 11,
If(Conceptofbl3n = 'INTANGIBLES', 12,
If(Conceptofbl3n = 'OTROS GASTOS POR AMORTIZAR ', 13,
If(Conceptofbl3n = 'GASTOS INICIALES DE INSTALACION', 14,
If(ConceptoCXP = 'PROVEEDORES' AND Conceptofbl3n = 'PROVEEDORES', 15,
If(ConceptoCXP = 'PROVEEDORES FILIALES', 16,
If(ConceptoCXP = 'PRESTAMOS POR PAGAR FILIALES', 17,
If(ConceptoCXP = 'ACREEDORES DIVERSOS', 18,
If(ConceptoCXP = 'DOC. POR PAGAR C.P.', 19,
If(Conceptofbl3n = 'IMPUESTOS DIFERIDOS', 20,
IF(Conceptofbl3n = 'RESERVA OBLIGACIONES CON TERCEROS',21,
If(Conceptofbl3n = 'CAPITAL SOCIAL', 22,
If(Conceptofbl3n = 'OTRAS CUENTAS DE CAPITAL', 23,
If(Conceptofbl3n = 'RESULTADO DE EJERCICIOS ANTERIORES',24,
If(Conceptofbl3n = 'VENTAS',25,
If(Conceptofbl3n = 'COSTO DE VENTAS',26,
If(Conceptofbl3n = 'GASTOS DE ADMNISTRACION',27,
If(Conceptofbl3n = 'DEPRECIACION ACUMULADA',28,
If(Conceptofbl3n = 'GASTOS FINANCIEROS',29,
If(Conceptofbl3n = 'OTROS INGRESOS(GASTOS)',30,
If(Conceptofbl3n = 'IMPUESTOS Y PTU', 31
)))))))))))))))))))))))))))))))
but this is what i got with this expression:
im using this to apply, i tried use the expression directly but works the same, somebody can explain why it dont work?
i tried too unify the concepts as the same, but still got nothing
I would be to create an inline table or load from an excel file the sorting order. (Easier to maintain)
Anyway, try Max($(#OrdernAnalitica))
or
try using the same expression on the data load editor and create a column like Sort_Order
On the chart use that field to sort