Bar Chart - Group by ID, but Display Name

[Anonymous]

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

[MK_QSL]

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

[anbu1984]

Check this qvw

[Anonymous]

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

[Anonymous]

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.

[anbu1984 · Accepted solution]

Dimension

Dual(Name,ID)

Product

Expression

Sales

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

[MK_QSL]

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

[Anonymous]

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

[Anonymous]

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.