Exclude values

[priyarane]

Hi Community,

I have field that have manu values but I don't wanted show particular value from that list through button action.

For Ex:

Filed_Test:

AA

BB

CC

DD

RR

FF

.

.

.

.

I wanted to show all except DD.

[Peter_Cammaert]

Create a listbox with a calculated dimension, like

=IF (Field_Test <> 'DD', Field_Test)

Add some logic that tests a button-controlled variable to see whether the listbox should show all values or filter some.

Best,

Peter

[maxgro]

Found this .qvw, maybe it can help you

[Mark_Little]

Hi,

Quickest is like Peter has suggested, if you are going to be using in a number of places i would do it in script.

like

IF(Field_Test <> 'DD', Field_Test)  as Field_Test1,

Mark

[reddy-s]

Hi Priya,

For restricting values in a list field , "IF" condition will serve your purpose as mentioned above my Mark and others.

[priyarane]

Above all suggestion can work out in List box but I have to show the result in Straight table as dimension.

[Mark_Little]

Well all the above options would work in both a list box and dimension.

just add a calculated dimension, although if scripted you can just add it.

Mark

[sunny_talwar]

Then use a calculated dimension (Peter's suggestion should still work)

=IF(Field_Test <> 'DD', Field_Test)

[hemhund2016]

Hi ,

Use it in the straight table as below.

Dimension :  =IF(Field_Test <> 'DD', Field_Test)

Make sure you set the "Supress When value is null" for dimension.

Thanks,Hemanth.

[thakkarrahul01]

Calculated dimension with if condition should do the job.