topic Re: Problem with space in trigger, GetFieldSelections() and Selection List in QlikView

Problem with space in trigger, GetFieldSelections() and Selection List

Mon, 07 Mar 2016 17:16:36 GMT

Hello,

I have a little problem:

- I load a list in an inline mode in my main script

LOAD * Inline

[%_Zone_art

'Class1'

'Class2'

'Class3'

'Product Manager'

'Priority Level'

'Product'

];

- I add a selection list in my program

- I add triggers to always have 'Class 1' selected if no record is selected (I want this one and not only one selected)

%_Zone_art

='('&if(GetSelectedCount( %_Zone_art )=0,'Class1' ,GetFieldSelections( %_Zone_art,'|' ) )&')'

My problem is when I select 'Product Manager', the selection is erased fos this record... I can't select it.

When I remove space and name it 'ProductManager' it is OK...

Have you got an idea ?

Thank you,

Willy

sunny_talwar — Mon, 07 Mar 2016 17:27:26 GMT

Try this as your trigger expression

='("'&if(GetSelectedCount( %_Zone_art )=0,'Class1' ,GetFieldSelections( %_Zone_art,'"|"' ) )&'")'

UPDATE: Added " double quotes to the expression so that it can handle spaces in field.

Mon, 07 Mar 2016 22:27:51 GMT

Hello,

thank you very much.

I will try on wednesday and tell you.

Regards,

Willy

Wed, 09 Mar 2016 07:54:26 GMT

Hello,,

your answer is correct.

Thank you very much.

Willy