Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Put selections in a Variable

I need to put in the caption of a report de selections that it uses.

For exemple if I select some offices the title will be something like  (Financial State of Barcelona, New York, Los Anglees, Berlin, Tokio)

How can I do? I saw that it's possible to use de function in a macro called GetCurrentSelection, but it return Not Madrid, Mexico D.F and I need the name of all office that I select.

Thanks

Sorry for my little English.

roger

1 Reply
Not applicable
Author

Hi Roger,

You need to use the getfieldselections function and specify the max values you need it to display. So in your case you need something like: getfieldselections(FieldName,',',30). This would show citynames upto 30 values.

Cheers,

Shyam