Issue with Multi-Box

[Anonymous]

Hi All,

We have a requirement, where based on on flag, the multi-box, a list of values should be restricted as per the value in the flag.

We tried, if-else condition, but it takes a lot of time.

Can anyone please suggest, how to achieve this.

Thanks & Regards,

MK

[sunny_talwar]

May be restrict the field in the script itself.

If(Condition = Met, Field) as MultiBoxField

and use this as your dimension for Multi Box Object

[diwakarnahata]

Hi,

The problem we are facing with the IF condition is that the Field has ~1 million distinct values. So, evaluating the if condition takes >40 secs.

We are looking for alternatives to optimize this.

Currently, we have used the below expression to populate the field.

IF(flag=$(vflag1) AND flag2=$(vflag2), Field)

Also, the flags used are binary 1/0 and the expression is used from variable into the multibox.

Let me know if there are any better ideas to optimize this implementation.

Thanks and Regards,

Diwakar

[diwakarnahata]

Any ideas on the above?

[rwunderlich]

Perhaps faster with Set Analysis like:

=aggr(only({<flag={"$(vflag1)"}>*<flag2={"$(vflag2)"}>}Field), Field)

Apologies if I didn't get the syntax exactly right.

-Rob