Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

building a Year comparison graphic

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:

12321.jpg

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

3333.png

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

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Julio,

Here´s your file and the final result.

julio.png

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.

View solution in original post

18 Replies
Clever_Anjos
Employee
Employee

1) Swap the order of your dimensions

2) Into Style Tab, change to "Grouped"

Carlos_Reyes
Partner - Specialist
Partner - Specialist

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

One question selected.png

Not applicable
Author

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.

Not applicable
Author

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?

Carlos_Reyes
Partner - Specialist
Partner - Specialist

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.

Not applicable
Author

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

Carlos_Reyes
Partner - Specialist
Partner - Specialist

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.

Clever_Anjos
Employee
Employee

Is it possible to attach your qvw?

I´ll create the graph for you

Not applicable
Author

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?