topic Row field values in QlikView

Row field values

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Row field values

mbespartochnyy — Wed, 01 Feb 2017 14:56:26 GMT

Hello,

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

Mikhail B.

Re: Row field values

krishnacbe — Wed, 01 Feb 2017 14:57:09 GMT

Hi,

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

Re: Row field values

vishsaggi — Wed, 01 Feb 2017 15:06:27 GMT

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

Re: Row field values

nareshthavidishetty — Wed, 01 Feb 2017 15:43:16 GMT

Hi,

The current report design should have Invoice # as dimension.

Thanks..

Re: Row field values

vishsaggi — Wed, 01 Feb 2017 15:47:36 GMT

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

Re: Row field values

mbespartochnyy — Wed, 01 Feb 2017 16:03:44 GMT

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.

Re: Row field values

mbespartochnyy — Wed, 01 Feb 2017 16:06:39 GMT

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

Re: Row field values

nareshthavidishetty — Thu, 02 Feb 2017 10:05:31 GMT

Hi,

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

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

Thanks..

Re: Row field values

Thu, 02 Feb 2017 10:10:21 GMT

Use the Expression:

Concat ([Invoice #], ', ')

This will help you..

Re: Row field values

mbespartochnyy — Thu, 02 Feb 2017 13:00:00 GMT

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