Filter listbox values

[#1]

Hello

How do you filter listbox values?

Eg:

I have a listbox containing customers.

Lets say i have from A to Z customers:

A

B

C

D

E

F

G

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())

[#2]

Check Hide Excluded in General Tab.

[#3]

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

[kaushiknsolanki]

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

[#5]

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.

[#6]

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

[kaushiknsolanki]

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

[er_mohit · Accepted solution]

ok

then try this way

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

[#9]

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

[nizamsha]

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