Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Above

Hello everyone, I have doubts with Above. I need to add the 1 of my column #Subio

the expression you used was


If Above (Price) <Price )


But at the time of adding this expression does not give me anything in the column of T

otal Subio For this column

I did the expression = Aggr (sum (if ( Above (Price) <Price ), CCO_CompanyName, CC_Mes)


buena.png

13 Replies
sunny_talwar

What are you summing?

=Aggr(Sum(If(Above(Price) < Price, TrueCondition), CCO_CompanyName, CC_Mes)

Anonymous
Not applicable
Author

The times I have 1 in the #Subio column by CC_Mes and CCO_Name

sunny_talwar

Not sure I understand

Anonymous
Not applicable
Author

I want to count the 1 of the #Subio column but per month

sunny_talwar

What is #subio column's expression?

Anonymous
Not applicable
Author

if(

Above(Precio)<Precio,1,0

)

sunny_talwar

May be try this

=Aggr(Sum(If(Above(Price) < Price, 1, 0), CCO_CompanyName, CC_Mes)

or just this

=Sum(If(Above(Price) < Price, 1, 0)

Anonymous
Not applicable
Author

I already tried both but it does not work

Anonymous
Not applicable
Author

In fact a parentesis is missing but still does not work

=Aggr(Sum(If(Above(Precio) < Precio, 1, 0)),CCO_CompraANombre, CC_Mes)