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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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'}