topic Re: Set analysis question in QlikView

Set analysis question

maxime_gerard — Wed, 13 May 2015 08:05:06 GMT

Hello everybody,

I am trying to make some set analysis and I don't understand why some of them don't work (Qlik even reject the synthax) :

I want to have everything but '*NULL' :

=only({-<Field={'*NULL'}>} Field) doesn't work

=only({<Field><{'*NULL'}>} Field) doesn't work

And here I want to return the create user that correspond to the min of the create dates:

=only({<ActionCreateDate={$(vMinCreateDate)}>} ActionCreateUser)

with vMinCreateDate=min(ActionCreateDate)

Any idea of what's wrong with that?

Re: Set analysis question

sunny_talwar — Wed, 13 May 2015 10:41:55 GMT

Try this to exclude Nulls

=Only({<Field={'*?'}>} Field)

But make sure the output is a single number for Only to display anything for you

for your second expression, try this:

=Only({<ActionCreateDate={"$(vMinCreateDate)"}>} ActionCreateUser)

HTH

Best,

Sunny

Re: Set analysis question

jonathandienst — Wed, 13 May 2015 10:58:49 GMT

Only({<Field-={'*NULL'}>} Field)

The editor will complain of a syntax error on the -= but that is a bug in the editor syntax checker and can be ignored. if you prefer, don't use the shorthand:

Only({<Field={*} - {'*NULL'}>} Field)

HTH

Jonathan