Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

get specific values from concat function

Hello

suppose I used concat(distinct field1) and suppose this function returns 5 values (A,B,C,D,E)

I how can I get what is the fifth value from the concat function

is this possible or is there an alternative

please advise

I can walk on water when it freezes
2 Replies
Gysbert_Wassenaar

=subfield(concat(distinct field1,'|'),'|',5)


talk is cheap, supply exceeds demand
ali_hijazi
Partner - Master II
Partner - Master II
Author

how can get each value then

cause I'm trying to have a line chart with one dimension and n expressions N is maximum 5

and I want to make my five expressions be as dynamic as possible

because they will represent the available maximum 5 releases or the selected ones

I can walk on water when it freezes