topic List Box Expression Duplicates Column in QlikView

List Box Expression Duplicates Column

Wed, 02 Jul 2014 20:22:41 GMT

I have this expression in my Region list box:

(Region<>'Unassigned' AND len(Region)>0,Region)

Which seems to work fine in the right-hand column, however I only want the right hand column to show. Any ideas?

Re: List Box Expression Duplicates Column

Anonymous — Wed, 02 Jul 2014 20:24:52 GMT

instead of using that expression in the Expressions tab of the listbox properties, try this: in general tab, scroll down to the bottom of the drop down for "Field" and select <Expression> and insert the expression in your post there.

Re: List Box Expression Duplicates Column

Wed, 02 Jul 2014 20:27:30 GMT

Welp, that was embarassing

Thanks!!

Re: List Box Expression Duplicates Column

Anonymous — Wed, 02 Jul 2014 20:28:53 GMT

it's all good...i've been there quite a few times and still find myself there every now and then