topic Re: Filter listbox values in QlikView

Filter listbox values

Thu, 11 Jul 2013 08:37:49 GMT

Hello

How do you filter listbox values?

Eg:

I have a listbox containing customers.

Lets say i have from A to Z customers:

and so on.

But in my charts there is only data for A,B,D.

So i want my listbox only to show A,B,D and not all the others because they dont have any data on them.

I would think something like this, but it is not working:

=if(sum({$<"[DimCustomer].CustomerName"=>} "[FactQVTimeRegistered].TimeRegistered") >0,"[DimCustomer].CustomerName", null())

Re: Filter listbox values

Thu, 11 Jul 2013 08:41:09 GMT

Check Hide Excluded in General Tab.

Re: Filter listbox values

Thu, 11 Jul 2013 08:44:06 GMT

No - This will only hide excluded when i have selected something. I want it to filtered when nothing at all is selected

Re: Filter listbox values

kaushiknsolanki — Thu, 11 Jul 2013 08:45:12 GMT

Hi,

If they dont have any data at all, you can delete them from data model only.

Give one where condition while loading the data in application.

Regards,

Kaushik Solanki

Re: Filter listbox values

Thu, 11 Jul 2013 08:46:57 GMT

I cant delete them from the data model, cause i use them elsewhere, where they have data.

But on this particulary mesure, they dont all have data.

Re: Filter listbox values

Thu, 11 Jul 2013 08:53:26 GMT

But wildmatch be massive, I have 100s of customers? There must be an easier way?

Re: Filter listbox values

kaushiknsolanki — Thu, 11 Jul 2013 08:59:33 GMT

Hi,

Then in your data model you can create a new field which is a customer who have the value for this measure.

Regards,

Kaushik Solanki

Re: Filter listbox values

er_mohit — Thu, 11 Jul 2013 09:06:41 GMT

then try this way

aggr(only({$<[FactQVTimeRegistered].TimeRegistered"={'>0'}>}[DimCustomer].CustomerName"),[DimCustomer].CustomerName")

Re: Filter listbox values

Thu, 11 Jul 2013 09:10:48 GMT

Thats true! But i there is a way in qlikview i would rather do it there. But thanks!

Re: Filter listbox values

nizamsha — Thu, 11 Jul 2013 09:14:04 GMT

aggr(only( {<fieldname={'a','b','c'}>}fieldname),fieldname)

Re: Filter listbox values

nizamsha — Thu, 11 Jul 2013 09:15:36 GMT

aggr(only($ {<fieldname={'a','b','c'}>}fieldname),fieldname)

Re: Filter listbox values

Thu, 11 Jul 2013 09:19:49 GMT

brillant.

What does the aggr and only do? Why cannot i use sum?