topic Re: List Box Expression Null Value in QlikView

List Box Expression Null Value

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have two fields in my list box. The first (left side) is the company IDs and the second field (right) is the expression (payment type) I have written in the expression tab of the list box. I need your help in removing the null values from the right side so the company IDs with corresponding payment type is shown.

Can someone guide me towards on how to implement this if it's possible at all?

Thanks in Advance,

Re: List Box Expression Null Value

sunny_talwar — Mon, 14 Mar 2016 13:38:54 GMT

What is your current expression? and are you trying to remove Company IDs where the expression is Null?

Re: List Box Expression Null Value

richard_chilvers — Mon, 14 Mar 2016 13:39:33 GMT

You might want to aim for a Table object. It can list many fields and has the option to Omit rows where a field value is null.

HTH

Re: List Box Expression Null Value

Mon, 14 Mar 2016 13:42:08 GMT

My current expression in the expression tab is POS.paymenttype and the general tab expression is POS.companyids. Yes Sunny I'm trying to remove company IDs where the expression (paymenttype) is NULL.

Thanks,

Re: List Box Expression Null Value

sunny_talwar — Mon, 14 Mar 2016 13:43:59 GMT

Have you tried this as your list box expression?

If(Len(Trim(POS.paymenttype)) > 0, POS.companyids)

Re: List Box Expression Null Value

Mon, 14 Mar 2016 13:55:21 GMT

Thanks everyone for your kind help.