Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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.