Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Selecting Values in ListBox having Calculated Field(using macro)

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


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

4 Replies
Contributor III
Contributor III

Hi Sumit,

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


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

is that not feasible

Contributor III
Contributor III

No Not Feasible

Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein