Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Line Chart no bar option for expression

all,

I am building a line chart. X axis is Quarter and Y is Revenue (bar chart) and growth (line chart).

  • I chosed the line chart. I have one dimension Quarter, and two expressions. I would like sum(Revenue) be in bars. but the option 'bar' in tab Display Option is grayed...

why is it so ?

  • I want to display revenues for Q1 2012, Q2 2012, Q3 2012, Q4 2012, Q1 2013 etc... quarters and years are two separate dimensions. if i set year and quarters as 2 dimensions for the chart, it is displaying four line charts and X axis are years. how can i build this line chart ?

Thanks

Ce message a été modifié par : cl bld

1 Solution

Accepted Solutions

Re: Line Chart no bar option for expression

Select COMBO Chart,

DImension :

Quarter-Year

Expessions:

1) SUM(Revenue) - Select Bar and Untick Line option

2) SUM(Growth) or whatever your dimension - Select Line and untick Bar option

8 Replies
iktrayanov
Contributor III

Re: Line Chart no bar option for expression

Go on the General tab and choose the Combo Chart(third option).

Re: Line Chart no bar option for expression

Select COMBO Chart,

DImension :

Quarter-Year

Expessions:

1) SUM(Revenue) - Select Bar and Untick Line option

2) SUM(Growth) or whatever your dimension - Select Line and untick Bar option

MVP
MVP

Re: Line Chart no bar option for expression

Hi,

Instead of Bar Chart select Combo Chart, if you dont have Quarter-Year dimension arrive it in script like

LOAD

*,

'Q' & Ceil(Month(DateDimensionName)) & '-' & Year(DateDimensionName) AS Quarter-Year

FROM DataSource;

take Dimension as Quarter-Year and use the following expressions

Sum(Revenue) - Select Bar

Sum(Growth) - Select Line option and uncheck Bar option

Hope this helps you.

Regards,

Jagan.

suresh_rawat
Contributor II

Re: Line Chart no bar option for expression

Hi Oilandgas,

If you want one expression shows in bar chart and one in line chart.

Then you have to use Combo chart for such representation.

Please refer the attached image.

Hope this will work out for you.

Regards

Suresh Rawat

gupta_n8
Valued Contributor II

Re: Line Chart no bar option for expression

USE COMBO Chart, as this chart type facilitates the combination of Bar and Line chart.

Regards

Nitin

raghavsurya
Valued Contributor

Re: Line Chart no bar option for expression

Hi,

Select Combo chart and you can enable both bar and line for your expressions.

Regards,

Raghav

Not applicable

Re: Line Chart no bar option for expression

Thanks.

i have already a variable 'Quarter' and a variable 'Year'

can i build in the Combo Chart wizard directly the Quarter-Year variable ? how to ?

Thanks

MVP
MVP

Re: Line Chart no bar option for expression

Hi,

I am not talking about variable, create additional dimension in script for Quarter-Year and use this expressions.  If possible can you attach the sample file.

Regards,

Jagan.

Community Browser