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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
Labels (1)
2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

=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