Qlik Sense How to create group combo chart bar and line

[elaineng]

I need to plot a graph on the total sales and average selling price of each type of product quarterly.  This is the sample data, I would like to plot the Sales in bar and average by lines similar to the attached below. How can I achieve in qlik sense? I have tried combo box but I can't group the product in bar.. and bar chart won't give me line chart either.

[SunilChauhan]

when you load this excel load fields will appear like  Sum of Sales1,2,3  because qlik does take duplicates column name and auto Name it as 1 2 3

LOAD
"Row Labels",
"Sum of Sales",
"Sum of Avg Price",
"Sum of Sales1",
"Sum of Avg Price1",
"Sum of Sales2",
"Sum of Avg Price2",
"Sum of Sales3",
"Sum of Avg Price3",
J,
K
FROM [lib://Test/QlikSense-SampleChart.xlsx]
(ooxml, embedded labels, header is 2 lines, table is Sheet2);

after load  take combo charts

1 DImesion :    ROw Label and

8 Expression:

Sum( [SumOf Slaes])

Sum( [SumOf Slaes1])

Sum( [SumOf Slaes2])

Sum( [SumOf Slaes3])

Sum([Sum of Avg Price])

Sum([Sum of Avg Price1])

Sum([Sum of Avg Price2])

Sum([Sum of Avg Price3])

checke attached file

you Can  Label you DImesion .

Hope this helps

[elaineng]

Thanks for the solution. Anyway not to make Product as a dimension as there are many products....