Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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¡