Combo Charts: How to make Line Graph Static while keeping Bar Graph Dynamic in Combo Charts in Qlikview ?

[#1]

Hi All,

I have a product A, which has sub-products A1, A2 & A3. I want to draw a combo chart where Bar Chart will represent individual sub-product (A1,A2 & A3) sales and Line graph will represent overall product sales (A).

For this i need to keep, A's line graph static while bar charts for A1,A2 & A3 as dynamic.

Please help.

Cheers

Prateek

[MK_QSL]

SUM(Sales) for Bar Chart

SUM(TOTAL <Product> Sales) for Line Chart

[#3]

Hi Manish,

X-Axis: Date

Sales here means # of units and NOT the revenue

Sales (A) = Sales(A1) + Sales(A2) + Sales(A3)
Bar chart has to be: Sales(A1) OR Sales(A2) OR Sales(A3)

Whereas,

Line Chart has to be: Average Sales (A1,A2,A3)

[MK_QSL]

Provide sample data please..

[#5]

Key        Cust_Name       Product    Month

1                ABC                A1         JAN

2                DEF                A1         JAN

3                GHI                 A2         JAN

4                JKL                 A3         JAN

5                MNO               A3         JAN

For the month of Jan,

Sales (A1) = 2 units , Avg Sales = 5/3
Sales (A2) = 1 units,  Avg Sales = 5/3

Sales (A3) = 2 units, Avg Sales = 5/3

Something on these lines

[MK_QSL]

Where is the sales column?