Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sazabi
Creator
Creator

Generating a list using GetFieldSelections() with Transformation

Greetings Qlikers,

 

I am looking to use GetFieldSelections() to generate a list of selected timestamps in their numeric form separated by commas.

=GetFieldSelections(num(timestampField),', '))

^- Does not do the trick 😞

Use Case:

User Selections the Dates: 5/8/2019, 5/9/2019

 

GetFieldSelections(num()) Returns: 43593, 43594

 

Any other way to do this?

 

Regards,

 

S

2 Replies
Vegar
MVP
MVP

I have not seen or heard of use like this, but you could try to do something like the code expression below.

Concat( NUM( subfield( GetFieldSelections(timestampField), ',')), ', ')
Vegar
MVP
MVP

If you can live without the criteria that it had to be selected and accept to include all associated timestampField then you could simplify your expression to this:

=Concat(NUM(timestampField), ', ')