topic Filter data in QlikView

Filter data

Tue, 03 Jul 2012 20:10:20 GMT

I have the following output on the dashboard

Material Inventory Qty Safety Stock Bookings Qty Excess Inventory Qty Excess Inventory $

ABC 1000 500 200 1000-500-200 = 300 $100

XYZ 100 500 200 (600) ($250)

How can i filter the data such that it shows only those rows that have a positive value in the excess inventory column and excess inventory $ column?

Re: Filter data

MayilVahanan — Tue, 03 Jul 2012 20:18:26 GMT

Hi,

Try this,

= if(([Inventory Qty] - [Safety Stock] - [Booking Qty]) > 0, ([Inventory Qty] - [Safety Stock] - [Booking Qty]))

Hope it helps

Re: Filter data

Tue, 03 Jul 2012 20:29:43 GMT

I currently use this expression but it still displays material XYZ with no value in the excess inventory qty column. I don't want to display the material at all if the excess inventory quantity is negative.

Thanks

Re: Filter data

Tue, 03 Jul 2012 21:09:40 GMT

Depending on the kind of controller, you may tell it to hide null values using the formula passed by

Mayil Vahanan Ramasamy

check the post "damn you zero and nulls" on http://qlikman.blogspot.com.br/