topic create string from possible values in a field in QlikView

create string from possible values in a field

Thu, 17 Feb 2011 17:20:12 GMT

Hi All

I have a table with names, email addresses, statuses etc. of all my users, some of them are active some are inactive. What I want is to create a button that for a selection of users e.g. those with staus=active will create a draft email in my outlook and paste all the email addresses from the table. I have already added ';' at the end of each address so it would separate one from another. It does work if i choose just one address with ='maito:' [field name]

I assume I have to create a sting of values from the possible email adresses to then put it into [field name] place.

Has anyone tried it before? Any advice?

Cheers for your help. Tom

create string from possible values in a field

Thu, 17 Feb 2011 17:22:55 GMT

The Concat() function gives possible values of a field.

Concat(Email, ';')

You can also add Set Analysis:

Concat({<Status={'Active'}>} Email, ';')

create string from possible values in a field

Thu, 17 Feb 2011 17:30:56 GMT

Perfect.

That's all i wanted.

Cheers

Tom

Re: create string from possible values in a field

Wed, 13 Mar 2013 15:26:53 GMT

Dear Miller,

I would like to obtein the followin result from a concat function:

'field(i)','field(i+1)','field(i+2)',...,'field(n)'

ex:

'1/1/8','2/6/90','4/14/45'

i'm not able to concatenate the: '

i need this solution, because i'm tring to update in a dinamic way the result of a match function, without changing the script (but only a variable in an input box and adding a line in an excel document)

I wanted to explain this becase if you have another way of thinking should be great!

Thank You !

Smirik