Filtering in table

[Amit_B]

Hi,

I need some help, I don't understand what i do worng.

I have a table with 3 columns - ItemID, WarehouseID, Location, StockQuantity.

I want to display only items where the WarehouseID is not equal to several values, and the ItemName no inculde 'extra' (anywhere in the name). I wrote the next condition (as dimention) and it not work for me:

if(not (match(WarehouseID, 101,105 107 116) or wildmatch(ItemName,'extra')), ItemID)

(QS August 23)

Thanks.

[Anil_Babu_Samineni]

Perhaps this

Load ItemID, WarehouseID, Location, StockQuantity From Table

Where Not wildmatch(WarehouseID, 101,105 107 116) or Not wildmatch(ItemName,'*extra*');

[Amit_B]

Thanks for the reply.

I need to do it in the UI sheet in the table settings. I set this as a dimension in the table.

[Anil_Babu_Samineni]

@Amit_B Please do like this then as calculated dimension

If(Not wildmatch(WarehouseID, 101,105 107 116) or Not wildmatch(ItemName,'*extra*'), ItemID)