1 Reply Latest reply: May 3, 2013 6:14 AM by Mohit Sharma RSS

    First day of using QlikView Personal and running into problems

      I am trying to get to grips with QlikView Personal to simplify some monthly reports that I run.

       

      The report I am trying to generate is for our Monthly Sales Report by Salesman.  I have a spreadsheet with all the Account Numbers against the Salesman Names, and have edited the connection in QlikView to connect to the SQL Database where the invoice information is stored.

       

      I have managed to bring up the data into a table, but would like to pre-format the table as follows:

       

      Month         Jan      Feb      Mar      Apr     May     Jun     etc

      Salesman1

      Salesman2

      etc

       

      I would like to then have a drop down to select the year to show their turnover, and then create a linked chart to show the Customers allocated to a chosen salesman and how they make up the monthly figure

       

      I have the table almost complete, but no idea on how to merge down the months instead of showing separate dates?

       

      Can anyone help a novice out on this please?

       

      Many thanks in advance

       

       

      Peter