topic Re: quick Syntax chec in QlikView

quick Syntax chec

samuel_brierley — Mon, 07 Sep 2015 14:59:10 GMT

Hi all,

can you please just scan your eyes over the below, its not returning a value

=count({$< ArbitrationInput.Group.rOOk = {"$=only{$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval])"} >} Timestamp)

Re: quick Syntax chec

MK_QSL — Mon, 07 Sep 2015 15:05:44 GMT

=count({$< ArbitrationInput.Group.rOOk = {"$(=only{$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]))"} >} Timestamp)

Re: quick Syntax chec

samuel_brierley — Mon, 07 Sep 2015 15:07:43 GMT

Nope unfortunately not working, thanks for trying.

Re: quick Syntax chec

maxgro — Mon, 07 Sep 2015 19:23:46 GMT

=count(

{$<

ArbitrationInput.Group.rOOk=

{"$(=only(

{$<[/rec/parameter]={rOff},[/#text]={CommonParameters},[Config]={Live}>}

[/rec/parameter/curval]))"}

Timestamp)

Re: quick Syntax chec

sasiparupudi1 — Mon, 07 Sep 2015 19:34:06 GMT

put it in a text box and see if returns a value

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

hth

Sasi

Re: quick Syntax chec

MarcoWedel — Mon, 07 Sep 2015 21:59:34 GMT

please post a sample app including some data and the object you're using this expression with.

regards

Marco

Re: quick Syntax chec

qlikviewwizard — Tue, 08 Sep 2015 00:18:45 GMT

Hi samuel brierley,

Please provide a sample qvw to demonstrate your issue. Thank you.

Re: quick Syntax chec

samuel_brierley — Tue, 08 Sep 2015 07:39:45 GMT

Hi all,

thanks for all your replies and sorry ive not gotten back you sooner, kiddly winks needed picking up from school.

anyway as per fookin usual a good sleep identifies the issue,

i missed a bracket after the only, i didnt see it because i already have a curly bracket there, duh!!!

=count({$< ArbitrationInput.Group.rOOk = {"$=only({$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval])"} >} Timestamp)