Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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
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
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
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