Show or load values that equal och above 0

[#1]

Hi,

Im trying to show values from a field called "Balans" but it contains lots of -1 and 0 values. I want to present this in tabel or tablebox but i want to get rid of the - and 0 values,

ive tryed a bunch of stuff like in Qlikview format dont show null values but this is not enough.

any ideas, can i do a load statement anybody?

thx

Theodor

[oknotsen · Accepted solution]

Add to your load script:

where Balans >0

[#3]

Thx solved it by putting your example in

SQL SELECT *

FROM "DBNAME".dbo.DBNAME

WHERE Amount >=1;