topic Show or load values that equal och above 0 in QlikView

Show or load values that equal och above 0

Wed, 28 Oct 2015 10:58:01 GMT

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

Re: Show or load values that equal och above 0

oknotsen — Wed, 28 Oct 2015 13:49:17 GMT

Add to your load script:

where Balans >0

Re: Show or load values that equal och above 0

Wed, 28 Oct 2015 14:48:34 GMT

Thx solved it by putting your example in

SQL SELECT *

FROM "DBNAME".dbo.DBNAME

WHERE Amount >=1;