topic Re: Above in QlikView

Above

Anonymous — Wed, 26 Jul 2017 15:04:56 GMT

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)

Re: Above

sunny_talwar — Wed, 26 Jul 2017 15:19:21 GMT

What are you summing?

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

Re: Above

Anonymous — Wed, 26 Jul 2017 15:33:32 GMT

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

Re: Above

sunny_talwar — Wed, 26 Jul 2017 15:35:40 GMT

Not sure I understand

Re: Above

Anonymous — Wed, 26 Jul 2017 15:38:43 GMT

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

Re: Above

sunny_talwar — Wed, 26 Jul 2017 15:39:59 GMT

What is #subio column's expression?

Re: Above

Anonymous — Wed, 26 Jul 2017 15:42:04 GMT

if(

Above(Precio)<Precio,1,0

)

Re: Above

sunny_talwar — Wed, 26 Jul 2017 15:47:20 GMT

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)

Re: Above

Anonymous — Wed, 26 Jul 2017 15:55:54 GMT

I already tried both but it does not work

Re: Above

Anonymous — Wed, 26 Jul 2017 16:01:42 GMT

In fact a parentesis is missing but still does not work

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

Re: Above

sunny_talwar — Wed, 26 Jul 2017 16:07:43 GMT

May be try adding all your dimension in Aggr() function

Re: Above

Anonymous — Wed, 26 Jul 2017 16:17:48 GMT

=Aggr(Count(If(Above(Precio) < Precio, 1, 0)),SC_Almacén,CC_Mes,CCO_CompraANombre,Producto,SC_Descripcion)

Neither works

Re: Above

sunny_talwar — Wed, 26 Jul 2017 16:27:31 GMT

Would you be able to share your app? And also the numbers you expect to see?

Re: Above

Anonymous — Wed, 26 Jul 2017 16:56:56 GMT

I send the excel with the results that should come out