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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with if in the expresion. Should i use AGGR?

Hi, in this expression

if(SUM({<Mes=, Anio=, TipoCal=>}if (adjudicado=1, CantidadCotizada))

                      - sum({<Mes=, Anio=, TipoCal=>} CantidadEntregada) = 0,

                                  SUM ({<Mes=, Anio=, TipoCal=>} (CantidadEntregada)))

What i'm doing is a sum, but i have this Condition

if(SUM({<Mes=, Anio=, TipoCal=>}if (adjudicado=1, CantidadCotizada))

                      - sum({<Mes=, Anio=, TipoCal=>} CantidadEntregada) = 0

Actually, is a very simple thing. If the sum of the first field - the sum of the second field is equal to 0, we do the sum. And all of those expressions have set analisys, because i dont wanna have my expressions influenced by "mes", "anio", "tipocal"

Ok, here is the problem. The conditional works with the total of Cantidad1 - Cantidad2, but i wanna divide this by "Article" and "Group" for example.

Should i use aggr function? how i use this function with the set analysis?

thank you!

Greetings

1 Reply
Not applicable
Author

Can you pls explain what you mean by - divide by "Article" and "Group"

Is this in a straight table?

Can you attach a sample file?

Thanks