topic Re: Selection in listbox in QlikView

Selection in listbox

Anonymous — Tue, 14 Aug 2012 23:43:39 GMT

I have a column A in my straight table displaying an column of expression with 30 rows of numbers 0.0 till 5.0. I want to create a listbox to display 3 selections -

Column A <=1,

column A >=1 and <=2,

column A >=2.

Any idea how to do this in a listbox? Thanks

Re: Selection in listbox

shree909 — Wed, 15 Aug 2012 04:21:02 GMT

hi , in the expression of the list box u can write the if condition that may works.

Re: Selection in listbox

IAMDV — Wed, 15 Aug 2012 06:28:56 GMT

Hi,

You have two options.

1. Change your field "A" within your script to show the DUAL format using DUAL() based on above conditions

2. Create a data island then use the Select in Field action

Although, I prefer the first method because it's clean and easy to maintain.

Cheers,