Using virtual column <= 0

[engelmo]

I would like to select data from a column, for example [Qty in stock] <=0

I cannot use this expression for a virtual column, what can you suggest me please.

Thank you all!

[Hussein_Osseily · Accepted solution]

So you want a list of the stock that is less than or equal to 0 

Why not create a slice of that table with expression: 
[QTDADE EN ESTOQUE]=<0

To creat a slice : 

Data
Slice / New Slice / Select the table / and write down the expression / and select then the columns to be included in the slice 

Once you creat the slice, you can go back to UX and creat a view for that slice

Virtual Column Would give you a type list and not a list of items as in a table form

[Hussein_Osseily]

Would you please elaborate ? what kind of result you are expecting in that virtual column ?
list ? number ? 

[engelmo]

I want to select my stock that sold out. or whatever stock <=0
that way I'll know which one I have to put back in stock.

[Hussein_Osseily · Accepted solution]

So you want a list of the stock that is less than or equal to 0 

Why not create a slice of that table with expression: 
[QTDADE EN ESTOQUE]=<0

To creat a slice : 

Data
Slice / New Slice / Select the table / and write down the expression / and select then the columns to be included in the slice 

Once you creat the slice, you can go back to UX and creat a view for that slice

Virtual Column Would give you a type list and not a list of items as in a table form

[williamsanj13 · Accepted solution]

Hi @engelmo ,
i think for your problem, better using slice and enter the condition on slice condition, after that, to show the result, you can select the slice data on UX table
no issue on your formula expressions

hope can help you, thanks