topic Re: Creating sbarcharts in QlikView

Creating sbarcharts

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

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?

Below graph is what I am looking for:

adamdavi3s — Mon, 20 Feb 2017 12:45:19 GMT

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 — Mon, 20 Feb 2017 12:48:11 GMT

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 — Mon, 20 Feb 2017 12:52:32 GMT

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 — Mon, 20 Feb 2017 13:01:04 GMT

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