Create a list using a delimiter (Qlik Sense)

[rafakmargos]

Hello!

I have this standard table that relates TAG with the Server Code, as here:

And I'm creating a URL that will be opened by a button in Qlik that need's to link the TAG with the server, like here:

....def-0.s-a.xml'&'&tag='&GetFieldSelections(TAG,',',50)&'&source='&[1,2,2,1,1]

As I'm using filters in my table, I used the function GetFieldSelections to allow the user to select the TAG's that he want to create the URL to after it he see the informations that he needs.

One important thing in the creation of the URL is the server of the TAG, that is inserted in front of the word 'source' (bold above)

How can I relate the server number with the TAG's that I selected in an expression?

[tensini · Accepted solution]

In script, add a "AutoNumber()" field:

LOAD
TAG,
SERVER,
AutoNumber(TAG) as TAG_ID
;
load * Inline [
TAG, SERVER
1234-1A, 1
5923-2B, 2
2312-3G, 2
3212-1B, 1
23121-4G, 1
];

Expression:

'....def-0.s-a.xml' & '&tag=' & Concat(distinct TAG,',',TAG_ID) & '&source=' & Concat(distinct SERVER,',',TAG_ID)

[rafakmargos]

Hi, @tensini 

It worked pretty good!

Thank you so much!