topic How can I group items that fall under the same list? in QlikView

How can I group items that fall under the same list?

neena123 — Fri, 02 Mar 2018 18:28:15 GMT

Below is a bundle that has been broken out. Unfortunately, if a bundle is not broken out you cannot see the item of the individual items under that bundle. The first picture is what I have currently in my report. How can I make it into the second picture?

Is there a way I can transform the data into this below:

Re: How can I group items that fall under the same list?

isingh30 — Fri, 02 Mar 2018 19:53:25 GMT

Sort Line Number in ascending order.You can hide related line no column as well. What table is it?

Thank you!

Re: How can I group items that fall under the same list?

neena123 — Fri, 02 Mar 2018 19:59:15 GMT

Thanks for the reply! But that wouldn't work since the Line number can be reused. To make it unique I would have to use the Order Number and Invoice number. I guess my example wasn't very clear.

Re: How can I group items that fall under the same list?

isingh30 — Fri, 02 Mar 2018 20:19:27 GMT

Can you share your data or app?

Thank you!

Re: How can I group items that fall under the same list?

vamsee — Fri, 02 Mar 2018 20:47:37 GMT

Hello Neena,

According to what I have interpreted your data to be, the logic would be

Transform:

NoConcatenate

LOAD Distinct

Item,

NUM([Line Number]) as [Line Number],

//[Related Line Number],

Price

Resident Input;

Left Join(Transform)

LOAD Distinct

Item,

NUM([Related Line Number]) as [Line Number],

Price

Resident Input;

DROP Table Input;

Please find the attach qvw for the same. Please provide more data if this doesn't suite your need.

Thanks

Vamsee

Re: How can I group items that fall under the same list?

neena123 — Fri, 02 Mar 2018 21:28:31 GMT

Hi Ishtdeep, Sorry I can't share my qvw but I have attached a sample of data. You can see that there are the same line number used over again and to make it unique is the order number. Anything with a 0 means it is the Parent/Bundle. It also won't always say Bundle it can have any name but what will always stay the same is a 0 value for the invoice number.

Re: How can I group items that fall under the same list?

Qrishna — Sat, 03 Mar 2018 06:22:02 GMT

Hi Neena,

Make sure you follow the proper sorting of the numeric fields.check out the attached.