How to remove null values and '0' in script?

[#1]

Hi have some manger and employess data,amount is measure

now some mangers amount is zero or null

now i want restrict  mangers or employess who has zero amount or nul values

please help on that

thanks

,

[alexandros17]

Load

...

...

From

...

Where Amount <> 0 and not isnull(Amount)

Let me know ...

[vikasmahajan]

Another way in dimension you can use suppress null option please find attached setting

Vikas

[sujeetsingh]

where Len(Manager)<>0

[qlikmsg4u]

use where condition like where Amount <>0

Hope this will help

[MayilVahanan]

Hi

Try like this

in Expression

=Sum({<Manager = {"=Sum(Amount) <> 0"}>}Amount)

Script:

Load * from tablename where Amount <> 0 or Not IsNull(Amount);