topic Re: Modify formula to work in text box in QlikView

Modify formula to work in text box

samuel_brierley — Mon, 05 Jan 2015 15:00:44 GMT

Hi all, i have the following formula that I use in a table that has time as the dimension.

what I want to do is modify the formula in such a way that it counts the number of ones over the time period and put this into a text box.

thanks in advance

if( SwitchOnOffVariables.Group.onOffState = 'RUNNING' and
ArbitrationInput.Group.rQo = 250 and
below(ArbitrationInput.Group.rQo,1,1) > 250 and
below(ArbitrationInput.Group.rQo,2,1) > 250, 1,'')

Re: Modify formula to work in text box

alexandros17 — Mon, 05 Jan 2015 15:21:17 GMT

Try with

Sum(Aggr(

if( SwitchOnOffVariables.Group.onOffState = 'RUNNING' and
ArbitrationInput.Group.rQo = 250 and
below(ArbitrationInput.Group.rQo,1,1) > 250 and
below(ArbitrationInput.Group.rQo,2,1) > 250, 1,'')

,Time))

let me know

Re: Modify formula to work in text box

richard_chilvers — Mon, 05 Jan 2015 15:21:21 GMT

I'm not entirely clear what you need to achieve, but in yout text object you can have any string which might be straight text and fields or variables. The ampersand (&) joins the strings together.

So it might be something like:

='This is a line of text which includes the value of the field called STRING_FIELD' & STRING_FIELD

The 'field' could also be a variable.

Hope that helps.

Re: Modify formula to work in text box

samuel_brierley — Mon, 05 Jan 2015 15:23:44 GMT

Thats it thank you very much, a nice little learner there too