List box data

[priyarane]

Hi Experts,

I have to remove particular data from listbox like below

Dim1

0

50

100

150

250

800

and I want to remove only 50 from Listbox

Dim1

0

100

150

250

800

Thank you

[Gysbert_Wassenaar · Accepted solution]

Use an expression =if(Dim1 <> 50, Dim1) as field for the listbox

[priyarane]

Thank you Gysbert

[#4]

Hi !

Try with the match function :

where match(Dim1, 50) = 0 - It will keep all values except 50

if you want to add values it's very simple : match(Dim1, 50, 'Value2', 'Value3') = 0 (if it is text values place them between quotes)

if want to work by inclusion do '>0', it will keep only the values of the list.

[mightyqlikers]

Hi Priya,

use below expression in list box

=if(not Match(DIM,'50'),DIM)

Regards

Gamzee

[priyarane]

Hi Marie,

Even its working perfect like this

=

if(match(Dim1,50)=0,Dim1)

[priyarane]

Hi Gamzee,

Its woriking