topic Re: List box Expression in QlikView

List box Expression

Mon, 12 Jan 2015 07:08:11 GMT

Hi all,

what to do if I want to add or delete values from list box for next customized report .For example see following Image,Here have to delete Connection Number,Meter Status and add Debit amount for next report.Can anyone help.

Re: List box Expression

anbu1984 — Mon, 12 Jan 2015 07:20:45 GMT

If you have loaded _Dimension through Inline load, then add dimension "Debit Amount" in Inline load

If you don't want to ignore few dimensions, then try like this

=If(Not Match(_Dimension ,'Connection Number','Meter Status'),_Dimension)

Re: List box Expression

Mon, 12 Jan 2015 07:39:03 GMT

Hi anbu,

It's showing like this, What to do?

Re: List box Expression

anbu1984 — Mon, 12 Jan 2015 07:56:00 GMT

You added above expression in expression tab. Remove that and add it in General tab. Select Field drop down in General tab and select last <Expression> and add the expression here.

Re: List box Expression

Mon, 12 Jan 2015 08:59:16 GMT

Thank you Anbu ,Its working...