Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

create string from possible values in a field

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

create string from possible values in a field

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

Concat(Email, ';')


You can also add Set Analysis:

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


View solution in original post

3 Replies
Highlighted
Not applicable

create string from possible values in a field

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

Concat(Email, ';')


You can also add Set Analysis:

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


View solution in original post

Highlighted
Not applicable

create string from possible values in a field

Perfect.

That's all i wanted.

Cheers

Tom

Highlighted
Not applicable

Re: create string from possible values in a field

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