topic Filtering a listbox in QlikView

Filtering a listbox

Thu, 15 Apr 2010 17:17:28 GMT

Hi,

I have a question about the functionalities of a listbox in QlikView.

In my dashboard I have a listbox with is filled by the following column "USR_VA_LOGIN" of this query :

LOAD "USR_ID",

"QUPR_CD",

"USR_VA_LOGIN",

SQL SELECT *

FROM dbo."TU_UTILISATEUR"

And I'd like to filter my listbox to recover just the USR_VA_LOGIN where QUPR_CD is not null. Is there a possibility to filter directly my listbox with a graphic option or do I have to implement a WHERE clause in my query ???

Thx for you help.

Nicolas

Filtering a listbox

mike_garcia — Thu, 15 Apr 2010 17:35:33 GMT

Hi,

I can think of two options:

1. Modify the List Box to filer the Field Values using an Expression. To do this, Right Click > Properties > General Tab and, under the Field Section from the Drop down select <Expression> and the expression would be something like:

=if(not isnull(QUPR_CD), USR_VA_LOGIN)

2. Create a new field in the script (no need to use a where clause) like this:

if(len(QUPR_CD) > 0, USR_VA_LOGIN) as NewFieldName

That's what I would do. Hope this helps.

Mike.

Filtering a listbox

Thu, 15 Apr 2010 18:03:41 GMT

You can load just is not null

LOAD "USR_ID",

"QUPR_CD",

"USR_VA_LOGIN",

SQL SELECT *

FROM dbo."TU_UTILISATEUR"

WHERE EXISTS("USR_VA_LOGIN")

Filtering a listbox

Fri, 16 Apr 2010 08:24:22 GMT

Thx a lot, your first solution is working very well.

Nicolas