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

I want to do a Text box

I want to do a text box, with this sentence ( =if(modelo_masa = '260' , sum(produccion)) )  but i wat this operation alwais, without any selection and now only is avaible wen i select modelo 260, i want to do a different text box with each diferent modelo,

3 Replies
sunny_talwar

May be this:

Sum({<modelo_masa = {260}>}produccion)

maxgro
MVP
MVP

sum(  {$ <modelo_masa={'260'}>}  produccion)

sum(  {$ <modelo_masa={'another model'}>}  produccion)


or maybe with 1 instead of $


rubenmarin

Hi Joaquin, try with:

Sum({1<modelo_masa={'260'}>} produccion)

It will give you the value of that modelo_masa, ignoring all selections (because of the '1' in set analysis).

Edit: I think I didn't uderstand the question at the first time, maybe you're looking for what Sunny and Massimo posted