This content has been marked as final. Show 4 replies
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:
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: