Selecting Values in ListBox having Calculated Field(using macro)

[sumitratnani]

Hi Qliks,

I have a list box having expression as a Field.. I want to select specific values in ListBox using macro.

I could clear ListBox with

lb.Clear

But How to select particular field in listbox that has calculated field.

[Anonymous]

Hi Sumit,

If you select the list box last option will be expression there you can set the expression according to your need.

[avinashelite]

Why can't you create the expression Dimension in the script that will help you to avoid the macros ?

is that not feasible

[sumitratnani]

No Not Feasible

[jonathandienst]

When you use a calculated field in a list box, any selections you make are on the underlying fields, not the actual expression. So you could use a macro or an action (better than a macro) to select the underlying values. It is not possible to directly select the calculated value. You may need to convert the calculated field to a physical derived field during the load.