Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

Row specific values in pivot table


I am trying to pivot my data to create a list for use in Word mail merge.

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

I attach two pictures to show the issue - if there is more than one row then all the cells have the same value...

I need any solution, script or chart or macro. Can you help?

best regards


2 Replies

Can you share sample application and explain result set in excel?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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.