topic Re: continuous selection in QlikView

continuous selection

Anonymous — Sat, 26 Mar 2016 14:25:45 GMT

In my application there are fields where the end user must be prohibeted to make a discontinuous selection.

If such a field is a dual field or contains numbers it can be done by applying a trigger action on select like:

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

But the difficulty if that my field is of a text type and I don't want to turn it into a dual field. It means that I cannot apply an action like: ='>=' & min(FieldName) & '<=' & max(FieldName)

Is it somehow possible to select from min to max in a text Field based on a FieldIndex? For example: from minimal FieldIndex to maximal Field Index?

Thank you in advance,

Larisa

Re: continuous selection

swuehl — Sat, 26 Mar 2016 15:01:45 GMT

maybe like attached?

Re: continuous selection

Anonymous — Sat, 26 Mar 2016 15:10:33 GMT

Thank you!

Re: continuous selection

Anonymous — Sat, 26 Mar 2016 15:54:22 GMT

Hi Swuel,

As soon as I renamed the field values, it stopped working. Could you please have a look?

Thank you in advance,

Larisa

Re: continuous selection

swuehl — Sat, 26 Mar 2016 16:10:02 GMT

You need to create the compound search embedding the field values in double quotes when they contain e.g. spaces:

=CONCAT({1} chr(34)&FieldValue('FIELD',ValueLoop(vMinFV,vMaxFV) )&chr(34),'|')

Re: continuous selection

Anonymous — Sat, 26 Mar 2016 16:16:09 GMT

Thanks a lot!