Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Xolink1389
Creator
Creator

HELP with this EXPRESION and MAKING AN ORDER

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:

Xolink1389_0-1683745463069.png

Xolink1389_1-1683745506941.png

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

 

 



Labels (5)
1 Reply
vamsee
Specialist
Specialist

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