4 Replies Latest reply: Jun 8, 2011 7:19 PM by Johannes Sunden RSS

    Differentiating between excel files ? Time stamp??

      Hello Guys,

       

      I pulled up two excel spreadsheets for year 2009 and 2010, concatenated them because both have same columns (fields) just the diferent data. Now I am drawing a graph using data from both the files.

       

      I have to draw a graph showing the comparison between 2009 and 2010 data. Its like displaying how many male and female a company hired in 2009 and then 2010. But I am facing 2 problems:

       

      1) I added "year" as an extra column in both the sheets, because there is no column which we can use to differentiate the data of 2009 and 2010. Now I am using "Sex" and "Year" field as dimension and count (empID) as expression. I can show the comparison but when I click on Relative checkmark to show my comparison in %, its taking both the year data as a single piece and showing percentage. Eg.

       

      I have total data eg. 11000 records for 2009 and 12000 fro 2010. Now when i used concatenate , QV is treating it as a single table and then based on that its drawing a chart which gives following info:

       

      2009: M: 40%

                F:10%

      2010: M:45%

                F: 5%

       

      So its not taking as 100% for each year individually. ?? I want to display like 2009: M: 80% F: 20%

                                                                                                                     2010: M:70% F:30%

      Is it a way to do that?

       

      2) In futue I am gonna get these 2009 and 2010 data files directly from database.But still there is no way of differentiting between them as we don't have any column "Year". Is there way like while we pull data files from database we can add a timestamp ot something that can diff . between data for 2009 or 2010?

       

      Thank you

       

       

      Best,

       

      Yaman