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

Please tell me where is thw wrong statement

=Only({1} If(  Aggr(Rank(

(

sum({<TipoMovimiento={Venta}, Vendedor -={'DIAZ ACOSTA JANET DE LAS MERCEDES'}, Año={'$(varAñoAct)'}>}CantidadUnidades*PesoArticulo)

-

sum({<TipoMovimiento={Devolución},Vendedor -={'DIAZ ACOSTA JANET DE LAS MERCEDES'},Año={'$(varAñoAct)'}>}CantidadUnidades*PesoArticulo)

)

,

4, 3),Vendedor) = 1,Vendedor))

2 Replies
Clever_Anjos
Employee
Employee

It´s hard to find your problem without knowing your data.

Would you mind share a sample of your data?  Preparing examples for Upload - Reduction and Data Scrambling

Anonymous
Not applicable
Author

Maybe you have to use single quotes ' ' for TipoMovimiento because is a string:

TipoMovimiento={'Venta'} and TipoMovimiento={'Devolución'}