• Votes for this article no votes for this yet
  • Dashboard Insight Newsletter Sign Up

Building Your Visual Analysis Interface using QlikView

by Dashboard Insight, Dashboard InsightFriday, October 21, 2011

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.

Qlikview - visual analysis interface design
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.

Tweet article    Stumble article    Digg article    Buzz article    Delicious bookmark      Dashboard Insight RSS Feed
 
Other articles by this author

Discussion:

No comments have been posted yet.

Site Map | Contribute | Privacy Policy | Contact Us | Dashboard Insight © 2017