Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jtovarsanchez
New Contributor II

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

Re: Above

What are you summing?

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

jtovarsanchez
New Contributor II

Re: Above

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

Re: Above

Not sure I understand

jtovarsanchez
New Contributor II

Re: Above

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

Re: Above

What is #subio column's expression?

jtovarsanchez
New Contributor II

Re: Above

if(

Above(Precio)<Precio,1,0

)

Re: Above

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)

jtovarsanchez
New Contributor II

Re: Above

I already tried both but it does not work

jtovarsanchez
New Contributor II

Re: Above

In fact a parentesis is missing but still does not work

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

Community Browser