Discussion board where members can get started with Qlik Sense.
I have and cvs file with 10 columns, everytime I try an If statement it gives me an error
Idk what Im doing wrong
LOAD [ID orden] as [ID Orden],
[ID cliente] as [ID Cliente],
[ID vendedor] as [ID Vendedor],
[ID Producto] as [ID Producto],
If(Venta =200 and Venta= 400 and Venta < 600, '400-600',
If(Venta>=600 and Venta < 800, '600-800', '800+')))) as Range_Venta
Hope you can help, and thanks
If Venta can't be <200, this works. Otherwise need another if
If(Venta >=400 and Venta < 600 , '400-600',
If(Venta>=600 and Venta < 800, '600-800', '800+')) as Range_Venta
Don't you want anything to cover the 0-400 range?
You can put this in a QlikView Script and see how this one works:
LOAD * INLINE [
IF(Venta < 400, '0-400',
IF(Venta >= 400 and Venta <= 600, '400-600',
IF(Venta > 600 AND Venta <= 800, '600-800', '800+'))) AS Range_Venta
Drop Table Temp;
Added the .QVW as an attachment.
Hope this helps!