topic Re: Quick formula check in QlikView

Quick formula check

samuel_brierley — Thu, 08 Jan 2015 13:53:51 GMT

Hi all,

thanks for any help on this,

the below is a snippet of a formula that isnt evaluating.

the issue seems to be the only segment because if i replace it with its value (1200) it works fine.

any suggestions?

avg(IF(RampDataFilteringOutput.Loopp1.sORLoopK > 35 and RampDataFilteringOutput.Loopp2.sORLoopK > 35 and
ArbitrationInput.Group.rOOk < only( {$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval])
,1,2))

Re: Quick formula check

terezagr — Thu, 08 Jan 2015 13:56:46 GMT

I think it does not know what to evaluate - try to add a brackets as follow:(RampDataFilteringOutput.Loopp1.sORLoopK > 35 and RampDataFilteringOutput.Loopp2.sORLoopK > 35 and ArbitrationInput.Group.rOOk)

avg(IF((RampDataFilteringOutput.Loopp1.sORLoopK > 35 and RampDataFilteringOutput.Loopp2.sORLoopK > 35 and
ArbitrationInput.Group.rOOk) < only( {$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval])
,1,2))

Re: Quick formula check

samuel_brierley — Thu, 08 Jan 2015 13:59:40 GMT

Hi, thanks for the quick response, I dont think the brackets are the issue as the value works and ive just tried with creating a variable in the script and that worked too.

Re: Quick formula check

terezagr — Thu, 08 Jan 2015 14:04:00 GMT

have you tried put {'Live'} into a single quotes?

Re: Quick formula check

samuel_brierley — Thu, 08 Jan 2015 14:08:16 GMT

Again yup ive tried that, and ive also put the only statement in a text box to ensure that its actualy returning a number and it is. really quite annoying

Re: Quick formula check

terezagr — Thu, 08 Jan 2015 14:52:42 GMT

Could you please explain what you are trying to do with your formula?

Re: Quick formula check

stigchel — Thu, 08 Jan 2015 15:11:07 GMT

If the Only statement is returning a correct value in a seperate text box, the easy solution would be to create a variable with the only expression like (e.g. vParameter)

= only( {$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval])

DO include the = sign, so it will evaluate at the variable level, in your expression replace the Only(..... with

$(vParameter)

Re: Quick formula check

samuel_brierley — Thu, 08 Jan 2015 15:20:05 GMT

thanks this is the way Ive done it