topic Re: Is there any way to recreate this graph in qlikview? in QlikView

Is there any way to recreate this graph in qlikview?

Fri, 31 Jul 2015 05:22:55 GMT

Hi all

I am busy evaluating qlikview to see if we can use it. One of the graphs we regularly use is in the picture below. I can get the graph with just one month data but it stacks all the bars once I have more than one month. Also, I cannot seem to embed the table into the graph but that seems only reproducible by having the table separately.

Thanks

Re: Is there any way to recreate this graph in qlikview?

Gysbert_Wassenaar — Fri, 31 Jul 2015 05:43:01 GMT

If you create a bar chart with two dimensions and one expression you can make that kind of bar chart. It's also possible with one dimension and three expressions. You can't embed the table into the chart.The table indeed has to be created separately.

Re: Is there any way to recreate this graph in qlikview?

Fri, 31 Jul 2015 05:45:46 GMT

So you cannot have both multiple dimensions and expressions as I have above?

Re: Is there any way to recreate this graph in qlikview?

Gysbert_Wassenaar — Fri, 31 Jul 2015 05:54:01 GMT

That's not what I said. You can have

Two dimensions + one expression

One dimension + N expressions where N is a positive integer larger than 0.

As far as I can tell your chart fits one of those two scenario's.

Re: Is there any way to recreate this graph in qlikview?

vikasmahajan — Fri, 31 Jul 2015 06:21:17 GMT

Can you please check this link if your requirement fullfill using this

Stack Bar With 2 Scale

Vikas

Re: Is there any way to recreate this graph in qlikview?

robert_mika — Fri, 31 Jul 2015 06:28:28 GMT

Could you post your data or app?

You can add the table and the graph into container to make them better aligned.

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Is there any way to recreate this graph in qlikview?

Fri, 31 Jul 2015 08:57:42 GMT

Here is an example of the table. Being new I may not be using Qlikview properly- but as I understand it- my rows here would be the dimensions, the columns the expressions.

Regards