Discussion Board for collaboration on QlikView Scripting.
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??
Solved! Go to Solution.
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.
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.
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.