topic Re: Row specific values in pivot table in QlikView https://community.qlik.com/t5/QlikView/Row-specific-values-in-pivot-table/m-p/21569#M3589 <HTML><HEAD></HEAD><BODY><P>Can you share sample application and explain result set in excel?</P></BODY></HTML> Sat, 12 May 2018 02:20:18 GMT Anil_Babu_Samineni 2018-05-12T02:20:18Z Row specific values in pivot table https://community.qlik.com/t5/QlikView/Row-specific-values-in-pivot-table/m-p/21568#M3588 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to pivot my data to create a list for use in Word mail merge.</P><P></P><P>The problem that I have is that the data is type string, and Maxstring is a table-level function, where I need a row-level function</P><P></P><P>I attach two pictures to show the issue - if there is more than one row then all the cells have the same value...</P><P></P><P>I need any solution, script or chart or macro. Can you help?</P><P></P><P>best regards</P><P>Marty.</P></BODY></HTML> Fri, 11 May 2018 16:20:17 GMT https://community.qlik.com/t5/QlikView/Row-specific-values-in-pivot-table/m-p/21568#M3588 martynlloyd 2018-05-11T16:20:17Z Re: Row specific values in pivot table https://community.qlik.com/t5/QlikView/Row-specific-values-in-pivot-table/m-p/21569#M3589 <HTML><HEAD></HEAD><BODY><P>Can you share sample application and explain result set in excel?</P></BODY></HTML> Sat, 12 May 2018 02:20:18 GMT https://community.qlik.com/t5/QlikView/Row-specific-values-in-pivot-table/m-p/21569#M3589 Anil_Babu_Samineni 2018-05-12T02:20:18Z Re: Row specific values in pivot table https://community.qlik.com/t5/QlikView/Row-specific-values-in-pivot-table/m-p/21570#M3590 <HTML><HEAD></HEAD><BODY><P>Hi Martyn, Maxstring can be used in row-level, maybe you are using it in set analysis, and set analysis is applied at table-level.</P></BODY></HTML> Sat, 12 May 2018 09:42:47 GMT https://community.qlik.com/t5/QlikView/Row-specific-values-in-pivot-table/m-p/21570#M3590 rubenmarin 2018-05-12T09:42:47Z