topic GetFieldSelections help in QlikView

GetFieldSelections help

Mon, 05 Sep 2011 12:21:36 GMT

Hi,

I'm trying to create an expression which shows all the Fruit's selected from the listbox BUT it doesn't list them correctly when I select more than 6. - see attached.(textbox)

Basically, I want to be able to use this selection of 'Fruits' in a Set-Analysis expression, so it will also need a square bracket added to each fruit too.

For example :

AVG({$<Fruit={[Apple],[Pear],[Banana] }>}Value)

Any ideas/tips on how I can get all the selected fruits, with a square bracket done in an expression?

Much appreciated!

Re: GetFieldSelections help

Mon, 05 Sep 2011 12:25:40 GMT

='[' &Concat(Fruit,',') & ']'

UPDATE

in case you need every value in brackets:

=Concat( '[' &Fruit & ']' , ',')

GetFieldSelections help

Mon, 05 Sep 2011 12:37:40 GMT

HI,

You can print all selected fruits by passing parameters to the function GetFieldSelections()

It takes 3 parameters:

1. field name

2. Value Seperater

3. max number values to be display.

try this:

='[' & GetFieldSelections(Fruit,',',10) & ']'

Hope this will help you.

Niranjan M

GetFieldSelections help

Mon, 05 Sep 2011 13:14:53 GMT

Thanks for your help. I used both of your solutions : =Concat( '[' &Institution & ']' , ',')