Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Add the result of an Above

Good morning I would like to know how I can add the following expression:

My Expression is the Status =

If (Status = 'Subium', 1,0)

But now I need Total Subio to tell me how many rose in this case should give me 2, but it is not doing, someone could help me the way I calculate that expression is the following:

Sum

Evidence1.png

Thank you

evidencia1.png

Gracias¡

12 Replies
Anonymous
Not applicable
Author

Guys I have another doubt I passed my total price that went up to a general table where I qualify my suppliers and the expression I add the CC_MES but now it does not filter anything at all.


Count(Total if(

          Aggr(if(Above(Precio)>Precio,'Bajo', if(Above(Precio)<Precio,'Subio','Sin Cambios')),CCO_CompraANombre,Precio,CC_Mes,SC_Almacén)

          ='Subio',Precio))

evidencia.png

Digvijay_Singh

I don't see column 'Precio' here? The formula is using it, may be image is not showing it, not sure..

Anonymous
Not applicable
Author

You were right I lacked the price sorry¡