topic Re: merging some rows into one in QlikView

merging some rows into one

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

Hello community!

I have the scenario below:

ACCOUNT LEVEL_CP ACCOUNT DESCRIPTION

104001 P11000 Commercial Bank Account

123000 P11200 Accounts Receivable

123003 P11200 Holdback Receivable

How do I show this in one line like that:

ACCOUNT LEVEL_CP ACCOUNT DESCRIPTION LEVEL_CP1 ACCOUNTDESCRIPTION1 LEVEL_CP2 ACCOUNTDESCRIPTION2

104001 P11000 Commercial Bank Account P11200 Accounts Receivable P11200 Holdback Receivable

I must show this in a pivot table if is possible.

Does anyone knows how to make this up?

Thank y'all.

Re: merging some rows into one

Anonymous — Thu, 22 Jun 2017 20:30:19 GMT

Something like this?

Re: merging some rows into one

martinqlik — Thu, 22 Jun 2017 20:46:43 GMT

Not exactly like this, because it comes in a qvd in that way below:

ACCOUNT LEVEL_CP ACCOUNT DESCRIPTION

104001 P11000 Commercial Bank Account

123000 P11200 Accounts Receivable

123003 P11200 Holdback Receivable

Some logic must be created in the script to show these informations in just one line.

Re: merging some rows into one

vishsaggi — Thu, 22 Jun 2017 20:59:04 GMT

How many rows of data your get from your QVD? You are saying technically if there are more than 10 rows of data all the 9 rows should be on right of the first row with 9*3=27 fields? Is this what you are looking for? If yes, what is the reason behind doing that way, what exactly you are trying to display here and what exactly is your requirement to show the user?

Re: merging some rows into one

Anonymous — Thu, 22 Jun 2017 21:09:12 GMT

I agree with vishsaggi‌ You should think about why you would want that many columns created.

What I provided should work in a pivot table.

If you need to do it in the load script I suggest you look at the generic load.

The Generic Load

Re: merging some rows into one

martinqlik — Thu, 22 Jun 2017 21:39:19 GMT

Thank you guys for answering.

What I meant to say was that I need to merge several rows into one alone.

Data comes from QVD in different rows, my client wants to classify these informations in one row because it's the correct way to analyse the context.

I have read generic load already, but not seems it will attend my purposal.

I may attach the qvw if you guys want to.

Re: merging some rows into one

Anonymous — Thu, 22 Jun 2017 21:47:10 GMT

That would be helpful.

Re: merging some rows into one

martinqlik — Thu, 22 Jun 2017 21:58:22 GMT

For example,

When I chosen 4015231 in the dimension filter JE_HEADER_ID, my table must show all data in one line, and not in three lines, like you can see.

Re: merging some rows into one

Thu, 22 Jun 2017 22:31:55 GMT

See Attached. Not Perfect.

Re: merging some rows into one

Anonymous — Fri, 23 Jun 2017 09:53:46 GMT

Hi,

Have you tried using the group by function to group the data into one table.

Perhaps this could help