topic Re: Stacked bar chart variant in QlikView

Stacked bar chart variant

Wed, 14 Oct 2015 09:51:54 GMT

I want to create a bar chart but i have three measures, two of which i want as a stacked bar chart and the other a straight bar chart

Example

Year Budget Expenditure Commitments

2015 500000 200000 150000

So in a bar chart I want to see one bar with Budget 500000

In the Second Bar chart I want to see Expenditure and Commitments stacked on top of each other with a different color.for each

Is it possible to do this, or would I just need to create a bar for each?

Re: Stacked bar chart variant

datanibbler — Wed, 14 Oct 2015 09:56:00 GMT

Hi,

that is possible, but only with a trick - you have to add a second dimension to your bar- or combochart (and correspondingly add some set_expression or IF_clause to your expressions).

HTH

B est regards,

DataNibbler

Re: Stacked bar chart variant

avinashelite — Wed, 14 Oct 2015 09:56:52 GMT

As per my knowledge , we can set the chart completely as stacked or independent bars but we don't have option of selective stack and bar show. You need to go with all the expression as stacked or individual bar of each one .

Hope this helps you

Re: Stacked bar chart variant

Wed, 14 Oct 2015 09:58:52 GMT

Can you maybe create me a example of what you mean?

Re: Stacked bar chart variant

Wed, 14 Oct 2015 10:00:08 GMT

Thought this could be a tough one if not impossible, would like to see what DataNibbler has to offer

Re: Stacked bar chart variant

avinashelite — Wed, 14 Oct 2015 10:02:55 GMT

ya, will see . I am also equally interested to see, is their a way to do that . Lets wait for DataNibbler

Re: Stacked bar chart variant

Wed, 14 Oct 2015 10:04:14 GMT

Hi,

i have already asked some thing like this,

Cobain Stacked and Grouped expression in one chart

but it seems that there is no straight way to do it,

you can do it using tow charts, one of them will be transparent

Re: Stacked bar chart variant

datanibbler — Wed, 14 Oct 2015 10:05:46 GMT

Hi,

I had the requirement a few times to have two expressions stacked and a third one beside it - not stacked on the first two.

It is only possible in a combochart to start with.

Unfortunately it's been a while since I did this, so I don't remember all the details.

But I think that is it: You need a combochart, then you add two dimensions to it and then you have to somehow make sure - via IF_expressions or so - that two of your expressions are displayed on the same value of the secondary dimension - thus they will automatically be stacked - and the third one is displayed on the other value of the secondary dimension.

Best regards,

DataNibbler

Re: Stacked bar chart variant

avinashelite — Wed, 14 Oct 2015 10:13:13 GMT

one alternate solution would be, use combo chart and create one expression with the Bar representation option and other with the line, this way you can show both in the same chart

Re: Stacked bar chart variant

datanibbler — Wed, 14 Oct 2015 10:19:49 GMT

Hi Avinash,

yes, that would of course work too - might be clearer, that depends on who is supposed to be working with this.

The way I suggested, however, is possible - pfa the solution.

Best regards,

DataNibbler

Re: Stacked bar chart variant

jyothish8807 — Wed, 14 Oct 2015 10:19:50 GMT

Hi Ander,

Yes we can do it.

Try creating stacked chart and in expresion use "if condition".

for eg:

Dimension field contains: Budget,Exp,Commi.

Create two expression.

in first exp: write your actual values you want to display.

in second exp: say if(Dimension=Budget,sum(Sales),if(Dimension=exp,0)).

Now like this you can have both stacked and single bar in same chart.

Hope it helps.

Regards

Re: Stacked bar chart variant

Wed, 14 Oct 2015 10:23:58 GMT

Thanks, looks good, but i will have a look at this and advise

Re: Stacked bar chart variant

Wed, 14 Oct 2015 10:25:29 GMT

Thanks, will have a look at this as well

Re: Stacked bar chart variant

avinashelite — Wed, 14 Oct 2015 10:38:50 GMT

Cool DataNibbler‌ , if we have limited set of values in the Dimension this work perfectly fine

I feel if we have more values in the dimension and if we want it to be dynamic then we might think , thanks for the sample file

Re: Stacked bar chart variant

Anonymous — Wed, 14 Oct 2015 10:54:30 GMT

please check the attached file

Re: Stacked bar chart variant

Wed, 14 Oct 2015 11:12:47 GMT

Good way , but I prefer the other option by DataNibbler

Re: Stacked bar chart variant

datanibbler — Wed, 14 Oct 2015 11:28:18 GMT

Hi Avinash,

I don't quite get you. More values in the dimension should not be a problem in itself, but I don't quite understand what you mean with it being dynamic? Do you mean the dimension being dependent on some condition?

Best regards,

DataNibbler

Re: Stacked bar chart variant

avinashelite — Wed, 14 Oct 2015 11:33:30 GMT

My point is in order to get the stack we are writing this

= IF(Dim_2=1, Expr_1) , = IF(Dim_2=1, Expr_2) and = IF(Dim_2=2, Expr_3)

expression rite. so if a new value called 3 gets added for the Dim_2 dimension than? we need to add one more expression rite? this was my point

Re: Stacked bar chart variant

datanibbler — Wed, 14 Oct 2015 11:37:58 GMT

Hi Avinash,

sure! With one more value to that secondary dimension, I'm not sure what would happen or what we could do.

In fact, that secondary dimension is (in my example) not a functional part of anything, it's just a trick (and thus completely arbitrary and artificial) to enable the part_stacking_part_grouping of the expressions.

Best regards,

DataNibbler

Re: Stacked bar chart variant

Wed, 14 Oct 2015 12:37:25 GMT

I have one question though. I understand exactly what you are doing. My issue though is I have the Dim2 Data in the same row as the Dim1 Data. I am just stuck finding my way around it. See attached summarised Data example