Solved: Re: Row field values - Qlik Community

nareshthavidishetty · ‎2017-02-01

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 · ‎2017-02-02

‌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.

View solution in original post

mbespartochnyy · ‎2017-02-01

Hello,

One option is to create an expression that would concatenate invoice numbers. Attached is an example.

Mikhail B.

krishnacbe · ‎2017-02-01

Hi,

You can add a expression as Concat([Invoice #],';') and remove the Invoice # from Dimension.

vishsaggi · ‎2017-02-01

Or as it is a pivot table, you can move the location to top of the Sum(Sales) Like this. Will it work ?

nareshthavidishetty · ‎2017-02-01

Hi,

The current report design should have Invoice # as dimension.

Thanks..

vishsaggi · ‎2017-02-01

IS this a question or a statement? Your dim has Invoice # ...

mbespartochnyy · ‎2017-02-01

Try this (See attached). I've adjusted the script to concatenate the invoice numbers there. This way you can see both concatenated or individual invoice numbers.

Mikhail B.

mbespartochnyy · ‎2017-02-01

You can actually simplify the script even further. Here's a revised version.

nareshthavidishetty · ‎2017-02-02

Hi,

I have used the below logic in script,but it is giving the below error.

Logic: Concat(A7BANB,';') as new,

Thanks..

Report Inappropriate Content · ‎2017-02-02

Use the Expression:

Concat ([Invoice #], ', ')

This will help you..