topic Re: get specific values from concat function in QlikView https://community.qlik.com/t5/QlikView/get-specific-values-from-concat-function/m-p/704096#M253950 <HTML><HEAD></HEAD><BODY><P>=subfield(concat(distinct field1,'|'),'|',5)</P></BODY></HTML> Wed, 18 Jun 2014 13:52:19 GMT Gysbert_Wassenaar 2014-06-18T13:52:19Z get specific values from concat function https://community.qlik.com/t5/QlikView/get-specific-values-from-concat-function/m-p/704095#M253949 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>suppose I used concat(distinct field1) and suppose this function returns 5 values (A,B,C,D,E)</P><P>I how can I get what is the fifth value from the concat function</P><P>is this possible or is there an alternative</P><P>please advise</P></BODY></HTML> Wed, 18 Jun 2014 13:51:01 GMT https://community.qlik.com/t5/QlikView/get-specific-values-from-concat-function/m-p/704095#M253949 ali_hijazi 2014-06-18T13:51:01Z Re: get specific values from concat function https://community.qlik.com/t5/QlikView/get-specific-values-from-concat-function/m-p/704096#M253950 <HTML><HEAD></HEAD><BODY><P>=subfield(concat(distinct field1,'|'),'|',5)</P></BODY></HTML> Wed, 18 Jun 2014 13:52:19 GMT https://community.qlik.com/t5/QlikView/get-specific-values-from-concat-function/m-p/704096#M253950 Gysbert_Wassenaar 2014-06-18T13:52:19Z Re: get specific values from concat function https://community.qlik.com/t5/QlikView/get-specific-values-from-concat-function/m-p/704097#M253951 <HTML><HEAD></HEAD><BODY><P>how can get each value then</P><P>cause I'm trying to have a line chart with one dimension and n expressions N is maximum 5</P><P>and I want to make my five expressions be as dynamic as possible</P><P>because they will represent the available maximum 5 releases or the selected ones</P></BODY></HTML> Wed, 18 Jun 2014 13:54:03 GMT https://community.qlik.com/t5/QlikView/get-specific-values-from-concat-function/m-p/704097#M253951 ali_hijazi 2014-06-18T13:54:03Z