Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Xolink1389
Creator
Creator

fix this issue

i have a problem with this expression

if(Concepto = 'VENTAS', 'Ventas Netas' & chr(10) & chr(10),
if(Concepto = 'COSTO DE VENTAS', 'Costo de Ventas' & chr(10) & chr(10),
if(Concepto= 'VENTAS' and Concepto= 'COSTO DE VENTAS', 'Utilidad Bruta' & chr(10) & chr(10))))

the problem is that 'Utilidad Bruta' not appers, i think the problem its because 'VENTAS' and 'COSTO DE VENTAS' match in the two first lines, so i trid to use this expression too but with not results

if(Concepto = 'VENTAS', 'Ventas Netas' & chr(10) & chr(10),
if(Concepto = 'COSTO DE VENTAS', 'Costo de Ventas' & chr(10) & chr(10),
if(match(Concepto, 'VENTAS' , 'COSTO DE VENTAS'), 'Utilidad Bruta' & chr(10) & chr(10))))

both are correct in syntaxis and when only try

if(match(Concepto, 'VENTAS' , 'COSTO DE VENTAS'), 'Utilidad Bruta' & chr(10) & chr(10))))

or

if(Concepto= 'VENTAS' and Concepto= 'COSTO DE VENTAS', 'Utilidad Bruta' & chr(10) & chr(10))))

the codes works but i need to use other lines, to solve it i used a table in line, but the concepts dont match since 'Utilidad Bruta' its a concept that dont exist so i use the expression to make it appers

what i mean? Concepto it linked to  account numbers so 'VENTAS' and 'COSTE DE VENTAS', are linked to many and diferents accounts and 'Utilidad Bruta' its the sum of both as result, so its a caculate data, so 'Utilidad Bruta' not exist in the code like  'VENTAS' and 'COSTE DE VENTAS'

im using the expression as a chart function

anybody can help me with that?

Xolink1389_0-1695747792846.png

this is what i get in the table

Labels (3)
0 Replies