7 Replies Latest reply: May 5, 2012 8:35 AM by swuehl RSS

    Creating a graph where you can choose different years... (noob)

    Erik Hultgren

      Hi!

       

      Im totally new to qlikview, i have tried to look at some videos and stuff but i have som questions now and im hopefull that someone here can help me out.

       

      Im having a excel file, with jan-dec and every month have a value say between "0-500" and then i have this information for 2 years. I have managed to create a barchart for each year, but i really want a graph just showing the "months" on the x-axis and the values on the y-axis. Then i want a listbox where i can choose between 2012 and 2013.

       

      But when i try to create a graph i only get dots and not the line between the dots, and also i don't know how to do to change between years.

       

      I hope this makes sence, it's quite hard to explain and english is not my native language.

       

      Thanks for all help!!

        • Re: Creating a graph where you can choose different years... (noob)
          swuehl

          windforce,

           

          I assume you do have a flat table with fields

           

          Year, Month, Value

          2011, Jan, 123

          ...

          2012, Jan, 231

          ...

           

          right?

           

          It might be best to create a date field from Year and Month and to convert your Month string field to a dual value field (this makes it much easier to sort your Month in chronological order later on).

           

          So maybe use two additional lines in your load like:

           

          LOAD Year,RAND()*500 as Value,

          date(date#(Year&Month, 'YYYYMMM')) as MonthStart,

          month(date#(Year&Month, 'YYYYMMM')) as Month

          INLINE [

          Month, Year

          Jan, 2011

          Feb, 2011

          Mar, 2011

          Apr, 2011

          May, 2011

          Jun, 2011

          Jul, 2011

          Aug, 2011

          Sep, 2011

          Oct, 2011

          Nov, 2011

          Dec, 2011

          Jan, 2012

          Feb, 2012

          Mar, 2012

          Apr, 2012

          May, 2012

          Jun, 2012

          Jul, 2012

          Aug, 2012

          Sep, 2012

          Oct, 2012

          Nov, 2012

          Dec, 2012

          ];

           

          Starting from this flat table, it should be easy to create a line chart, use Month as dimension, =sum(Value) as expression (since Month can hold multiple values for multiple years, you need to use an aggregation function here), and create a list box to choose a year (you can force always one selected value in list box properties).

           

          Please see attached,

          Stefan