Set analysis question

[maxime_gerard]

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?

[sunny_talwar]

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

[jonathandienst]

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