topic Re: Re: building a Year comparison graphic in QlikView

building a Year comparison graphic

Mon, 27 Jan 2014 16:23:20 GMT

Hi, I am trying to create a graph that I can see the evolution 2012/2013 in some question. I am trying to build a chart like this:

Problem is, each question is a column, and I am trying to build like this and the closer I get is this:

how can I change this graph into the first one??

Re: building a Year comparison graphic

Clever_Anjos — Mon, 27 Jan 2014 16:26:56 GMT

1) Swap the order of your dimensions

2) Into Style Tab, change to "Grouped"

Re: building a Year comparison graphic

Carlos_Reyes — Mon, 27 Jan 2014 16:32:05 GMT

Since each question is a column... which makes sense... just force the graph to be shown when there is only one question selected...

Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:11:47 GMT

it did not work, appears all the year 2012 answers, and then the 2013 answers, what i want is for each question a 2012 and next to it the 2013 bar.

Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:13:33 GMT

Like, this graph, "contact center" is a question about it, and then "field rep" is another question, so, what "Question" = 1 should I use there?

Re: building a Year comparison graphic

Carlos_Reyes — Mon, 27 Jan 2014 17:14:47 GMT

What Clever said should work... just place the Question field as first dimension and the Year field as second dimension. Use the "Grouped" option in Style tab.

Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:15:04 GMT

It didn't work exactly, it says "Calculation conditions unfulfilled"

Re: building a Year comparison graphic

Carlos_Reyes — Mon, 27 Jan 2014 17:17:12 GMT

I thought that you wanted to see the comparison between two years for all the months.. so I thought the X axis had to show the Months... which in that case you should only show one question so that the chart would make sense... but I think Clever's suggestion does what you want.

Re: building a Year comparison graphic

Clever_Anjos — Mon, 27 Jan 2014 17:19:01 GMT

Is it possible to attach your qvw?

I´ll create the graph for you

Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:19:37 GMT

yes, it works if in the expression I have only one expression. the thing is that I have more than one. how do I create that?

Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:22:26 GMT

Sure, i'll attach a .qvw here, just a minute

Re: building a Year comparison graphic

Clever_Anjos — Mon, 27 Jan 2014 17:24:03 GMT

Você é brasileiro

Re: building a Year comparison graphic

Carlos_Reyes — Mon, 27 Jan 2014 17:27:15 GMT

I think Clever will help you with that.

Re: Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:28:41 GMT

here it's the file...

Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:33:09 GMT

Thank you Carlos! I think Clever will be able to help me finishing this task.

Re: Re: building a Year comparison graphic

Clever_Anjos — Mon, 27 Jan 2014 17:48:34 GMT

Julio,

Here´s your file and the final result.

I´ve done a "quick ´n dirty" example, because you don´t have a another dimension to include into that graph.

I´ve created a calculated dimension to generate your dimension (FlyEmbraer, Claims and so on). A much better approach is having this into your tables.

Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:51:48 GMT

That's exactly what I wanted to do! thank you alot!

Re: building a Year comparison graphic

Clever_Anjos — Mon, 27 Jan 2014 17:52:52 GMT

If you want to improve that app, we can discuss it by direct mail or clever@clever.com.br

Re: building a Year comparison graphic

Mon, 27 Jan 2014 17:58:40 GMT

thank you man! I always wondered how I could do that!