Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Employee
Employee

Re: Re: building a Year comparison graphic

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.

18 Replies
Employee
Employee

Re: building a Year comparison graphic

1) Swap the order of your dimensions

2) Into Style Tab, change to "Grouped"

carlos_reyes_qv
Valued Contributor

Re: building a Year comparison graphic

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

Re: building a Year comparison graphic

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

Re: building a Year comparison graphic

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_qv
Valued Contributor

Re: building a Year comparison graphic

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

Re: building a Year comparison graphic

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

carlos_reyes_qv
Valued Contributor

Re: building a Year comparison graphic

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.

Employee
Employee

Re: building a Year comparison graphic

Is it possible to attach your qvw?

I´ll create the graph for you

Not applicable

Re: building a Year comparison graphic

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?