This week, I’m giving you a sneak peek at how you can use QlikView to build your visual analysis interface. If you have a data analyst mind like me, QlikView is a good option. In addition, if you don’t have a copy of QlikView, you can download their free edition here. Note that you can use QlikView to develop your dashboard entry, as well.
Click on the image to launch the video player.
Code snippet for loading
the data from the spreadsheet. (Be sure to replace the text in the square brackets with where the contest Excel file is located).
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='MM/DD/YYYY';
SET TimestampFormat='MM/DD/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
LOAD date(Monthname(ActivityMonth),'MMM yy') as ActivityMonth,
Amount,
ActivityType as ActivityID
FROM
[TheLocationOfTheContestExcelFile]
(biff, embedded labels, table is ExpenseDetails$);
INNER JOIN
LOAD
ActivityType as ActivityID,
ActivityDescription as ExpenseDescription
FROM
[TheLocationOfTheContestExcelFile]
(biff, embedded labels, table is ExpenseDetails$)
WHERE ActivityDescription <> 'Pay' and ActivityDescription <> 'Repayment'
and ActivityDescription <> 'Savings'
Example:
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='MM/DD/YYYY';
SET TimestampFormat='MM/DD/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
LOAD date(Monthname(ActivityMonth),'MMM yy') as ActivityMonth,
Amount,
ActivityType as ActivityID
FROM
[C:\Users\alexanderc\Desktop\Dashboard-Design-Contest-Data.xls]
(biff, embedded labels, table is ExpenseDetails$);
INNER JOIN
LOAD
ActivityType as ActivityID,
ActivityDescription as ExpenseDescription
FROM
[C:\Users\alexanderc\Desktop\Dashboard-Design-Contest-Data.xls]
(biff, embedded labels, table is ExpenseDetails$)
WHERE ActivityDescription <> 'Pay' and ActivityDescription <> 'Repayment'
and ActivityDescription <> 'Savings'
Additional Resources
If you are new to QlikView, we recommend you start here.
In addition, learn how to develop with QlikView here
Find out more about QlikCommunity here.