topic Re: Bar chart With Two dimension in QlikView

Bar chart With Two dimension

Wed, 18 Jun 2014 04:36:05 GMT

Hi All,

I want to create a bar chart with 2 dimension & two expression. One expression should be stacked sub type & other expression should be grouped subtype.

Any help would be appreciated.

Re: Bar chart With Two dimension

tresB — Wed, 18 Jun 2014 04:44:42 GMT

I am afraid that, this would not be possible in one chart here in qv.

Re: Bar chart With Two dimension

Wed, 18 Jun 2014 07:37:16 GMT

I don't know how to achieve it in qv, but in excel it's achievable to overlap these two chart type together and keep the front one to be transparent.

Re: Bar chart With Two dimension

selvakumarsr — Wed, 18 Jun 2014 07:49:28 GMT

To my knowledge this is not possible in QV...

Re: Bar chart With Two dimension

Wed, 18 Jun 2014 08:00:53 GMT

The same thing do in the qlikview create two different charts for each and set the transparency 100% and overlap them..

Re: Bar chart With Two dimension

Wed, 18 Jun 2014 08:17:10 GMT

yes we can overlap both graph & set transparency to 100% but then dimession will repeat two times,

one for stacked expression & one for grouped expression.

Re: Bar chart With Two dimension

Wed, 18 Jun 2014 09:01:09 GMT

Okay then hide the dimension of one chart labeling it by space.. try this

Re: Bar chart With Two dimension

Wed, 18 Jun 2014 09:17:10 GMT

Bhawna I did as you say, but if i remove dimension name ,then how one come to know which expression belong to which dimension....

Re: Re: Bar chart With Two dimension

Wed, 18 Jun 2014 09:25:42 GMT

It seems you want a line and bar chart,there is a combo chart option,I have created a sol sample have a look...

Re: Bar chart With Two dimension

Wed, 18 Jun 2014 09:47:17 GMT

It`s not have any data,

please share Budget.xls

Re: Re: Bar chart With Two dimension

Wed, 18 Jun 2014 10:02:16 GMT

PFA contains the application as well as data..

Re: Bar chart With Two dimension

Wed, 18 Jun 2014 10:18:47 GMT

This Chart is OK but my requirement is different

I have:

1)Annual plan year wise for salesman

2)Actual Plan month wise for salesman

I want All month grouped into a single bar & another bar for Annual Plan

Re: Bar chart With Two dimension

Wed, 18 Jun 2014 10:21:32 GMT

Could you please add your application sample to understand me your requirement.

Re: Re: Bar chart With Two dimension

Wed, 18 Jun 2014 10:46:56 GMT

PFA content.

I want both the chart to be combine.

Re: Bar chart With Two dimension

Tue, 24 Jun 2014 07:32:43 GMT

Any solution guys???

Re: Re: Bar chart With Two dimension

Anonymous — Tue, 24 Jun 2014 08:12:05 GMT

Hi,

See attachment.

Re: Bar chart With Two dimension

jagan — Tue, 24 Jun 2014 08:38:32 GMT

Hi Prashant,

Try like this

Script:

----------

Tab1:

LOAD Salesman,

Month,

Actual AS Value,

1 AS Category

FROM

[Budget.xlsx]

(ooxml, embedded labels, table is Sheet1);

Tab1:

LOAD Salesman,

Month,

[Annual Plan] AS Value,

2 AS Category

FROM

[Budget.xlsx]

(ooxml, embedded labels, table is Sheet1);

Now in chart use

Dimension : Salesman, Category

Expression1:=Sum({<Category={2}>}Actual)

Expression2:=sum({$<Category={1}, Month={Jan}>} Actual)

Expression3:=sum({$<Category={1}, Month={Feb}>} Actual)

Expression4:=sum({$<Category={1}, Month={Mar}>} Actual)

Expression5:=sum({$<Category={1}, Month={Apr}>} Actual)

Hope this helps you.

Regards,

Jagan.