Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
martynlloyd
Partner
Partner

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?

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.