4 Replies Latest reply: Dec 29, 2011 4:47 AM by Parag Patil RSS

    Date Grouping

      Hi,

       

      I am new to Qlikview and am working on a personal project to understand QV better.

      I have had the standard QV training available n-line but need a little help.

       

      I am importing transaction data from an SQLite Table and there is a field called TRANSACTION_DATE that I have imported.

       

      I have also created a seperate calendar table using the script below:

       

       

      [Calendar]:

      LOAD *, Month(TRANSACTION_DATE) as TRANSACTION_MONTH, Year(TRANSACTION_DATE) as TRANSACTION_YEAR;

      LOAD date(fieldvalue('TRANSACTION_DATE',RecNo())) as TRANSACTION_DATE AUTOGENERATE fieldvaluecount('TRANSACTION_DATE');

       

       

      My concern is that this will group dates as months but the sequencing of TRANSACTION_MONTH will be lost once I record transactions in January'2012. In short, JAN, FEB etc... will start apperating before SEP, OCT, NOV, DEC on the chart.

       

      I would like the dates to be represented as MMM-YY on the dimesion axis so that the sequence of TRANSACTION_MONTH can be maintained.

       

      I am attaching here, an excel chart representation of how I would like the data to be seen in QV:

       

      Chart.JPG