I don't know if you want to read the value but prevent showing that value in Qlikview, or if you just want to ignore negative values while you're reading the table.
Case 1 : You only want to load the table without negative values :
Table A:
A, B
pro1, 15
pro2, 30
pro3, -40
you only have to add "where num(B) >=0";
Case 2 : You only want to show positive values :
You have to use in your charts the function rangemax() like this :
rangemax(0,B), it will return B if it is positive, or 0 if it is negative.
Filter the negative rows out as part of the load script (load project,amount from file.txt (txt) where amount >= 0)
Create a separate field in the resident tale in the load script and use the new field for expressions (load project,amount, if(amount <0,0,amount) as amount_to_sum from file.txt (txt))
Load the data as is and do the calculation on the front end using an "IF" statement. (load project,amount from file.txt (txt) ----then --- sum( if(amount <0,0,amount) on the front end)
Option 1 will be the fastest on the front end, but you can only use this method if you NEVER will need the negative values in your model.
Option 2 will be slower then option 1 but faster that option 3 on the front end.
