Row field values

[nareshthavidishetty]

Hi ,

We are having same Employee id with two different invoice numbers as below.

Here for location 2 for emp id 222 i need to show invoice numbers as 345,346 with in a single row.

Attached is the sample application.

Thanks..

[mbespartochnyy · Accepted solution]

‌You need to add a Group By statemen to tell QlikView by which fields it should grip the invoice numbers. In the QVW you attached initially, we group invoice numbers by location and employee ID and then added the rest of the fields. Looking at the error message I see that you added few new fields to the script. Find out by which fields you want to group the invoice #s and then add a group by statement to group them by which ever fields you need.

Mikhail B.