topic Re: Line Chart no bar option for expression in QlikView

Line Chart no bar option for expression

Mon, 30 Dec 2013 21:53:48 GMT

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

Re: Line Chart no bar option for expression

iktrayanov — Mon, 30 Dec 2013 22:04:07 GMT

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

Re: Line Chart no bar option for expression

MK_QSL — Mon, 30 Dec 2013 22:09:00 GMT

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

Re: Line Chart no bar option for expression

jagan — Tue, 31 Dec 2013 02:18:29 GMT

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.

Re: Line Chart no bar option for expression

suresh_rawat — Tue, 31 Dec 2013 02:43:13 GMT

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

Re: Line Chart no bar option for expression

Anonymous — Tue, 31 Dec 2013 04:40:19 GMT

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

Regards

Nitin

Re: Line Chart no bar option for expression

raghavsurya — Tue, 31 Dec 2013 08:40:41 GMT

Hi,

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

Regards,

Raghav

Re: Line Chart no bar option for expression

Tue, 31 Dec 2013 09:08:06 GMT

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

Re: Line Chart no bar option for expression

jagan — Thu, 02 Jan 2014 02:02:57 GMT

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.