Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
stonecold111
Creator III
Creator III

filtering straight table expression

how can i filter my straight table expression

for >=0 and <0        values

Suggest qlikkss

11 Replies
stonecold111
Creator III
Creator III
Author

searchable in straight table not working

I posted sample data here .. plz have a look into that

Anil_Babu_Samineni

In fact, You should not use the Wild card like *<0*. It should be <0 and i am not sure why do you need -1 over the expression. I've removed and applied it's working

(sum(colum1)-sum(column2)-sum(column3))

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful