Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
martynlloyd
Partner - Creator III
Partner - Creator III

Row specific values in pivot table

Hi,

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

Marty.

2 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
rubenmarin

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.