topic Re: I want to do a Text box in QlikView

I want to do a Text box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: I want to do a Text box

sunny_talwar — Fri, 27 Jan 2017 18:27:13 GMT

May be this:

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

Re: I want to do a Text box

maxgro — Fri, 27 Jan 2017 18:27:38 GMT

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

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

or maybe with 1 instead of $

Re: I want to do a Text box

rubenmarin — Fri, 27 Jan 2017 18:28:36 GMT

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