topic Re: How to remove null values and '0' in script? in QlikView

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

Fri, 05 Sep 2014 09:15:23 GMT

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 — Fri, 05 Sep 2014 09:16:41 GMT

Load

...

From

...

Where Amount <> 0 and not isnull(Amount)

Let me know ...

vikasmahajan — Fri, 05 Sep 2014 09:22:51 GMT

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

Vikas

sujeetsingh — Fri, 05 Sep 2014 09:23:19 GMT

where Len(Manager)<>0

qlikmsg4u — Fri, 05 Sep 2014 09:43:23 GMT

use where condition like where Amount <>0

Hope this will help

MayilVahanan — Fri, 05 Sep 2014 09:51:42 GMT

Try like this

in Expression

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

Script:

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