topic Re: Selecting Values in ListBox having Calculated Field(using macro) in QlikView

Selecting Values in ListBox having Calculated Field(using macro)

sumitratnani — Mon, 29 May 2017 12:39:11 GMT

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.

Re: Selecting Values in ListBox having Calculated Field(using macro)

Anonymous — Mon, 29 May 2017 12:44:44 GMT

Hi Sumit,

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

Re: Selecting Values in ListBox having Calculated Field(using macro)

avinashelite — Mon, 29 May 2017 12:51:35 GMT

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

is that not feasible

Re: Selecting Values in ListBox having Calculated Field(using macro)

sumitratnani — Mon, 29 May 2017 12:54:47 GMT

No Not Feasible

Re: Selecting Values in ListBox having Calculated Field(using macro)

jonathandienst — Mon, 29 May 2017 13:14:38 GMT

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.