topic Difficulty to aggregate in QlikView

Difficulty to aggregate

Tue, 21 Apr 2015 15:27:13 GMT

Hi everyone,

I have been working today on an application but didn't succeed in it. I started with an Excel file of purchase. Each line represents a purchase of a product. However, one or many purchases are attached to one purchase bill, that has an ID.

My goal is to have in QV only a line per bill and where I has to add columns containing the products that has been purchased. I assume that a bill can contain only 10 products.

Thank you very much !

Re: Difficulty to aggregate

buzzy996 — Tue, 21 Apr 2015 15:33:14 GMT

share ur .qvw else sample data and expected output!

Re: Difficulty to aggregate

Tue, 21 Apr 2015 15:38:31 GMT

Re: Difficulty to aggregate

Anonymous — Tue, 21 Apr 2015 15:39:18 GMT

You can load your data as is, and on the front end charts use ID as dimension. Other data - aggregate in expressions, like sum() or count. If you need to aggregate text values, use concat().

For more specific answers - upload an example of your application.

Re: Difficulty to aggregate

Tue, 21 Apr 2015 15:39:59 GMT

Here is my input and excpected output, I couldn't build a working script yet because I don't know how to figure it out

Re: Difficulty to aggregate

Anonymous — Tue, 21 Apr 2015 15:45:00 GMT

Does the attached work for you?

Re: Difficulty to aggregate

Tue, 21 Apr 2015 15:47:01 GMT

I don't see any file attached

Re: Difficulty to aggregate

Anonymous — Tue, 21 Apr 2015 15:50:06 GMT

Can't help with that... Ask Forum admins for help.

(I see you have an answer from gwassenaar‌ here Transaction with different products in one line )

Re: Difficulty to aggregate

buzzy996 — Tue, 21 Apr 2015 15:51:00 GMT

see this

Re: Difficulty to aggregate

Tue, 21 Apr 2015 15:53:29 GMT

It works for me with your documents, however, could it be a problem not to be able to have distinct columns for products values?