topic Bar Chart - Group by ID, but Display Name in QlikView

Bar Chart - Group by ID, but Display Name

Anonymous — Fri, 24 Oct 2014 22:07:12 GMT

I am new to Qlik and working on a POC. In our data we have unique ids for each record; however, some of those records have the same name. I do not want to use the name dimension because I will end up grouping records that do not go together. I would like to use the id dimension but display the name. I have included some sample data below.

ID	Name	Product	Sales
1	Bob Jones	Product A	1500
1	Bob Jones	Product B	2000
2	Bob Jones	Product A	1000
2	Bob Jones	Product B	1000
3	Mary Jones	Product A	1000

Below is an example of what the final output would look like. This groups everything properly and Bob Jones is listed twice because he as two unique ids.

Is this possible in Qlik? I would appreciate any help.

Thank you

Re: Bar Chart - Group by ID, but Display Name

MK_QSL — Fri, 24 Oct 2014 23:27:56 GMT

Create a Key by using ID&Name as Key and use Key as a Dimension in your Bar Chart...

Re: Bar Chart - Group by ID, but Display Name

anbu1984 — Sat, 25 Oct 2014 03:01:01 GMT

Check this qvw

Re: Bar Chart - Group by ID, but Display Name

Anonymous — Tue, 28 Oct 2014 20:09:12 GMT

Unfortunately I cannot open the file since I am using the personal addition. Thanks for the response I appreciate all the help.

Re: Bar Chart - Group by ID, but Display Name

Anonymous — Tue, 28 Oct 2014 20:10:16 GMT

Thanks for the response. This isn't the most ideal solution as it requires a longer name and displays data that I would prefer not to show, it will work for the POC.

Thanks again.

Re: Bar Chart - Group by ID, but Display Name

anbu1984 — Wed, 29 Oct 2014 02:11:05 GMT

Dimension

Dual(Name,ID)

Product

Expression

Sales

Chart properties --> Style tab --> Orientation - Horizontal And Subtype - Stacked

Re: Bar Chart - Group by ID, but Display Name

MK_QSL — Wed, 29 Oct 2014 08:10:07 GMT

Thanks for choosing my answer as correct one but honestly speaking, the answer given by anbu1984 is more efficient than my answer....

Re: Bar Chart - Group by ID, but Display Name

Anonymous — Wed, 29 Oct 2014 12:11:06 GMT

Thanks. That is exactly what I was looking for. I appreciate all the help.

Re: Bar Chart - Group by ID, but Display Name

Anonymous — Wed, 29 Oct 2014 12:12:42 GMT

Thanks Manish. Your answer helped fill the immediate need and will be useful when I have some alternate situations where I cannot use the dual function as I do not have a numeric id.

I appreciate everyones help.