fill in the gaps by the means of a concat function

[Anonymous]

Hi,

I'd like to set an action to fill in the gaps in a user selection using a concat function.

There is numeric field A. I need to analise a user selection in the field A - I need to get the smallest value (Value X) and the biggest value (Value Y) among those which have been selected by the user. Then I should set the action = select in field A all values from X to Y. As a result gaps (in case there were any) will be filled in.

Which syntax is needed to implement this idea?

Thank you in advacne,

Larisa

[sunny_talwar]

Are you looking for select in field action? Something like this?

='>=' & Min(Field_A) & '<=' & Max(Field_A)

[maxgro · Accepted solution]

add a trigger

menù-->settings-->document properties -->field events triggers --> choose your field (mine is field) --> on select

--> add actions -->

='>=' & min(field) & '<=' & max(field)

[Anonymous]

It's a nice piece of advice!

Thank you.

I'm glad that QlikView is so flexible.