topic Dynamic window titles based on selection in QlikView

Dynamic window titles based on selection

Tue, 06 Apr 2010 15:04:05 GMT

I 'd like the window title of a chart to display the users selection of a small dimension. So, if the user select serveral elemens out of the dimension all of them should be displayed in the window title.

I know, usually this kind of requirements are implemented by the use of a "Current Selection Box" but this might not be an option here.

Thx

Ludwig

Dynamic window titles based on selection

deepakk — Tue, 06 Apr 2010 15:07:21 GMT

YOu can Specify the Field Name

eg :

= 'Customer Name is ' & CUSTOMERNAME

where CUSTOMERNAME is the field name.

Dynamic window titles based on selection

Tue, 06 Apr 2010 15:38:01 GMT

You can use an expression like this for your Windows title :

=if (GetSelectedCount(MY_SMALL_DIMENSION), ' Selections on my small dimension are' & GetFieldSelections(MY_SMALL_DIMENSION,', ',50) , 'String to display when there are no selections')

where MY_SMALL_DIMENSION is the name of your dimension, ',' is the string to display between two field selections, and 50 is the max number of items displays. for example if I've selected 51 items in my dimension and there are 2500 existing distinct values in this dimension, it will displays '51 of 2500 values' instead of the list of available items.

Best regards

Dynamic window titles based on selection

Tue, 06 Apr 2010 15:38:13 GMT

= 'Customer Name is ' & CUSTOMERNAME

will display a "-" if more than 1 CUSTOMERNAME is selected.

Use

= 'Customer Name : ' & concat(CUSTOMERNAME, ', ')

instead.

[EDIT]

Bertrand gave another good (proper) solution at the same time. 🙂

[/EDIT]

Dynamic window titles based on selection

Tue, 06 Apr 2010 15:58:35 GMT

I've added my solution to nmartin example.
(I've learned something today with the concat function 🙂 )
Both solutions work,

differences are :

when no selections are made :

- if you want to list all possible values => use the concat version
- if you want to display another thing => you can use the getfieldselections

on big selections :

- possibilities to display a ratio ( x values on y) with the getfieldselections

Regards