topic Re: Set analysis in QlikView

Set analysis

samuel_brierley — Mon, 03 Nov 2014 13:20:52 GMT

Quick Syntax check,

Can anyone see my error?? its on the final line some where

count({$<ArbitrationInput.Group.rOOk = {"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rRMk"},

ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rQo"},

ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rQMk"},

ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk <" only( {$ < [/rec/Parameter] = {'rFf'}>} [/rec/parameter/curval]) >} ArbitrationInput.Group.rOOk)

thanks all

Re: Set analysis

danieloberbilli — Mon, 03 Nov 2014 13:33:02 GMT

I think the last double quote must be at the end and not before only(...)

Re: Set analysis

MK_QSL — Mon, 03 Nov 2014 13:34:04 GMT

=count(

ArbitrationInput.Group.rOOk = {"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rRMk"},

ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rQo"},

ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rQMk"},

ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk < only({<[/rec/Parameter] = {'rFf'}>}[[/rec/parameter/curval])"}

>} ArbitrationInput.Group.rOOk)

Re: Set analysis

jonathandienst — Mon, 03 Nov 2014 13:35:31 GMT

First of all, these expressions look like line-by-line comparisons. A set expression is evaluated once for the whole chart and not line by line, so that logic will not work.

Secondly (this is only relevant if they are NOT line by line comparisons), the multiple conditions for the ArbitrationInput.Group.rOOk field will be the intersection of the possible values, rather than the union - I am not sure what you want here.

Finally, the last clause makes no sense to me. Does the Only expression apply to the whole data set, or to some dimension? If the latter, see point 1.Otherwise you could define a vriable like:

Set vExpr = =only({$<[/rec/Parameter] = {'rFf'}>} [/rec/parameter/curval]);

(The double = are not a typo).

And use the variable in the set expression. This is also evaluated once for the chart and not once per line.

HTH

Jonathan