Discussion Board for collaboration on QlikView Layout & Visualizations.
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)
What are you summing?
=Aggr(Sum(If(Above(Price) < Price, TrueCondition), CCO_CompanyName, CC_Mes)
The times I have 1 in the #Subio column by CC_Mes and CCO_Name
Not sure I understand
I want to count the 1 of the #Subio column but per month
What is #subio column's expression?
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)
I already tried both but it does not work
In fact a parentesis is missing but still does not work
=Aggr(Sum(If(Above(Precio) < Precio, 1, 0)),CCO_CompraANombre, CC_Mes)