topic Re: stacked barchart into batchart in QlikView

stacked barchart into batchart

Thu, 01 Nov 2012 07:23:15 GMT

im using 2 dimensions and morethan 1 expression then barchart show stacked

but i dont need stacked hoe to resolve this

im using trellis chart but it not good

plz give me the reply.

Thanks

Re: stacked barchart into batchart

Thu, 01 Nov 2012 07:55:15 GMT

u need trellis chart ?

how many dimensions & exprs in total ?

Re: stacked barchart into batchart

Thu, 01 Nov 2012 08:46:10 GMT

i have 2 dimensions and 2 expressions

in the style -subtype of the chart is grouped but it display as stacked

plz give without trellis chart

Re: stacked barchart into batchart

Thu, 01 Nov 2012 08:47:49 GMT

thanks for the reply

i dont need trellis chart

i have 2 dimensions and 2 expressions

then it automatically show as stacked

Re: stacked barchart into batchart

Thu, 01 Nov 2012 08:50:05 GMT

cud u pls post ur sample qvw....thoda check karna hoga abt exprs

Regards

Re: stacked barchart into batchart

Thu, 01 Nov 2012 09:04:52 GMT

now im using qv personal edition

in my chart 2 dimensions

for sample

empno,ename

expressiona

sum(sal),avg(sal)

im using just sample data

my chart display like this

Re: stacked barchart into batchart

Gysbert_Wassenaar — Thu, 01 Nov 2012 09:10:37 GMT

You have two dimensions and two expressions. Try using one calculated dimension: empno & ' ' & ename instead of both ename and empno. I assume that there's a one-to-one relation between ename and empno.

Re: stacked barchart into batchart

Thu, 01 Nov 2012 09:23:06 GMT

Thank you for your valueble information

now i get it.

Re: stacked barchart into batchart

Thu, 01 Nov 2012 09:25:12 GMT

so does it mean that if there is one to many relation between two dimensions then it shud nt show stacked?

Re: stacked barchart into batchart

Gysbert_Wassenaar — Thu, 01 Nov 2012 09:35:33 GMT

That depends. If you are aware of it and you want to show the combinations then you can do it that way. I assumed that ename and empno actually represent the same thing, an employee, so there is no need to use both dimensions.

A bar chart can show only three independent variables. So you're limited to two dimensions and one expression or one dimension and two expressions. If you have a hierarchy of dimensions (like year,quarter,month) you can 'stack' them on one axis.

Re: stacked barchart into batchart

Thu, 01 Nov 2012 09:44:43 GMT

thank u for ur information

in barchart ,

also use 3 dimensions with 1 expression

can u give some information about this.

Re: stacked barchart into batchart

Thu, 01 Nov 2012 12:37:13 GMT

das ok...i mean is it ever possible to show grouped expressions for multiple dimensions bcos i know for fact that the dimension wud always be grouped be it one-one or one-many relation.

In case of hierarchy its better to use drill down group otherwise the graph looks a mess