topic Re: How to filter data inside list box in QlikView

How to filter data inside list box

ecabanas — Fri, 03 May 2013 11:59:03 GMT

Hi,

I have a list box with some data, as I show in the picture, but I don't want to see the blank and null values, is it possible to filter them?

Thank's

Eduard

er_mohit — Fri, 03 May 2013 12:15:50 GMT

in script you have to do it

load

A,B

if(Fimilia<> '',Fimilia) as Fimilia

from

table;

if <Null> also your field value in Familia then

use this

if(Fimilia<> ''and Fimilia<> '<Null>',Fimilia) as Fimilia

hope it helps

MayilVahanan — Fri, 03 May 2013 12:57:13 GMT

Try like this

Either: in list box

if(trim(Len(Fimila)) > 0 or Fimila <> '<NULL>', Fimila)

or in load script:

Load

if(trim(Len(Fimila)) > 0 or Fimila <> '<NULL>', Fimila) AS Fimila

from table;

Hope it helps