topic Re: how it works? in QlikView https://community.qlik.com/t5/QlikView/how-it-works/m-p/696095#M1056070 <HTML><HEAD></HEAD><BODY><P>thanks rob </P><P>with ur motivation i did&nbsp; same and i understood how it works </P></BODY></HTML> Sat, 25 Oct 2014 10:53:06 GMT 2014-10-25T10:53:06Z how it works? https://community.qlik.com/t5/QlikView/how-it-works/m-p/696093#M1056068 <HTML><HEAD></HEAD><BODY><P>Hi experts, </P><P></P><P>pls expain me this ,</P><P></P><P>=$(=SubField(concat(distinct Dimension,&nbsp; '|'), '|', 1))</P></BODY></HTML> Sat, 25 Oct 2014 10:08:49 GMT https://community.qlik.com/t5/QlikView/how-it-works/m-p/696093#M1056068 2014-10-25T10:08:49Z Re: how it works? https://community.qlik.com/t5/QlikView/how-it-works/m-p/696094#M1056069 <HTML><HEAD></HEAD><BODY><P>I would suggest you read up on each function in the Help. Then put each piece of the expression into a text box to observe the results. For example, first start with:</P><P></P><P>=concat(distinct Dimension,'|')</P><P></P><P>And then add the subfield around it and so on.</P><P></P><P>-Rob</P></BODY></HTML> Sat, 25 Oct 2014 10:33:14 GMT https://community.qlik.com/t5/QlikView/how-it-works/m-p/696094#M1056069 rwunderlich 2014-10-25T10:33:14Z Re: how it works? https://community.qlik.com/t5/QlikView/how-it-works/m-p/696095#M1056070 <HTML><HEAD></HEAD><BODY><P>thanks rob </P><P>with ur motivation i did&nbsp; same and i understood how it works </P></BODY></HTML> Sat, 25 Oct 2014 10:53:06 GMT https://community.qlik.com/t5/QlikView/how-it-works/m-p/696095#M1056070 2014-10-25T10:53:06Z