topic Issue with Multi-Box in QlikView

Issue with Multi-Box

Anonymous — Wed, 02 Sep 2015 09:52:30 GMT

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,

sunny_talwar — Wed, 02 Sep 2015 09:55:22 GMT

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 — Wed, 02 Sep 2015 14:58:42 GMT

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 — Wed, 02 Sep 2015 20:17:11 GMT

Any ideas on the above?

rwunderlich — Wed, 02 Sep 2015 21:34:37 GMT

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