Creating sbarcharts

[sayadutt]

Hello Team,

I am new to qlikview.

I have a requirement where I need to show both bar chart and line chart in a single graph.

Can you please let me know how we can achieve this?

Date	No. of Merges	Daywise Total Merge
13-Dec	1	39
15-Dec	1	13
16-Dec	1	35
20-Dec	2	87
21-Dec	2	14
03-Jan	1	51
05-Jan	1	28
06-Jan	1	30
10-Jan	1	14
11-Jan	2	51
12-Jan	2	18
13-Jan	1	1
14-Jan	1	13
17-Jan	2	30
18-Jan	1	19
19-Jan	3	25
20-Jan	4	22
23-Jan	1	13
24-Jan	4	39
25-Jan	2	8
26-Jan	2	31
27-Jan	2	13
30-Jan	2	18
31-Jan	2	22

Below graph is what I am looking for:

[adamdavi3s]

This is one of the basic chart options in Qlikview

On the expression tab just choose one to show as line

On the axes tab make sure one expression is set to one axes and the other the other

[avinashelite · Accepted solution]

1.New Chart

2.Select combo charts

3.Dimension = Date

4.Expression = add the expression as per your requirement

5.In the expression >below the expression definition> select you need line or bars

Hope this helps you

[sarvesh]

Hi..Sayantan,

Chose "Date" in dimension and "No. of Merges" & "Daywise Total Merge" in measures, using this you can achieve your requirements.

Note: if your problem is solved then mark this Helpful & Correct.

Regard's

Sarvesh Srivastava

[rahulpawarb]

Hello Sayantan,

Trust that you are doing well!

Please follow below steps:

1. Load the data using script editor

2. Create new chart object and select Combo Chart (1st row - 3rd chart option)

3. Add Date as dimension

4. Add below given expressions

//Daywise Total

Sum([Daywise Total Merge])

//No. of Merges

Sum([No. of Merges])

5. Click Finish.

Regards!

Rahul