Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.
Please post sample app/data.
Thanks
Regards
Marco
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
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)
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...
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.
selecting <expression> from the field
Thx a lot