Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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

,

5 Replies
Highlighted

Load

...

...

From

...

Where Amount <> 0 and not isnull(Amount)

Let me know ...

Highlighted
Champion
Champion

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

Vikas

Highlighted
Master III
Master III

where Len(Manager)<>0

Highlighted
Specialist
Specialist

use where condition like where Amount <>0

Hope this will help

Highlighted

Hi

Try like this

in Expression

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

Script:

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