Load specific values list of selection

[#1]

How can i get only Bikes displayed in the box of selection with only "3 categories" and "97 products available" on the top. Thx in advance...

[MarcoWedel]

Please post sample app/data.

Thanks

Regards

Marco

[#3]

I don't know how to post a app/data

I just want Number of 'Bikes' with 'Product Line' and 'Product Model' corresponding displayed and nothing else..

My script

Thx in advance

[swuehl]

You should be able to reuse the expressions from the other list boxes, something like this:

In a new list box, create a title expression like

='Bikes: ' & count({<NameProductCategory = {Bikes}>} distinct ProductLine) & ' categories and  ' & count({<NameProductCategory = {Bikes}>} distinct ProductModelID) & ' products'

if you want to filter the Products, select <expression> from the field list drop down in general tab of list box properties and enter something like

=aggr( only( {<NameProductCategory = {Bikes}>} NameProduct), NameProduct)

[#5]

Hi,

Thanks for answwer,

I'm looking for something like this :

Categorie :

Only 'Bikes'.

I don't want the others categories displayed

Product Line: 3

Tourism

Mountain

Road

I don't want the others Product Line displayed

Product Model : 15

Thx in advance...

[swuehl · Accepted solution]

Would be easier if you could upload a small sample QVW.

In general, you can limit the values displayed in a list box by selecting <expression> from the field drop down list and enter something like a calculated dimension, e.g.

=if( Category = 'Bikes', ProductName)

You would need to replace Category and ProductName with your appropriate field names.

Use similar expressions to limit Product lines and Product Models.

[#7]

selecting <expression> from the field

Thx a lot