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

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

Thu, 15 May 2014 08:38:11 GMT

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

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

MK_QSL — Thu, 15 May 2014 08:48:38 GMT

SUM(Sales) for Bar Chart

SUM(TOTAL <Product> Sales) for Line Chart

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

Thu, 15 May 2014 09:00:23 GMT

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)

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

MK_QSL — Thu, 15 May 2014 09:11:11 GMT

Provide sample data please..

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

Thu, 15 May 2014 09:23:47 GMT

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

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

MK_QSL — Thu, 15 May 2014 10:11:06 GMT

Where is the sales column?