topic Load specific values list of selection in QlikView

Load specific values list of selection

Sun, 09 Aug 2015 11:21:01 GMT

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...

Re: Load specific values list of selection

MarcoWedel — Sun, 09 Aug 2015 11:57:45 GMT

Please post sample app/data.

Thanks

Regards

Marco

Re: Load specific values list of selection

Sun, 09 Aug 2015 12:23:48 GMT

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

Re: Load specific values list of selection

swuehl — Sun, 09 Aug 2015 12:36:42 GMT

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)

Re: Load specific values list of selection

Sun, 09 Aug 2015 15:29:55 GMT

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...

Re: Load specific values list of selection

swuehl — Sun, 09 Aug 2015 15:40:05 GMT

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.

Re: Load specific values list of selection

Sun, 09 Aug 2015 15:43:43 GMT

selecting <expression> from the field

Thx a lot