Quick Start


Quick Start:

  1. Launch logQL by double clicking “logQL.jar”.
  2. Locate the Sample Dataset(Help > Quick Start).
  3. Copy using Ctrl-C and paste it in Excel Ctrl-V.
  4. Save this as account.xls (any folder)
  5. Open the file in logQL:
    • From the menu, select File > Open > Excel
    • Select “…” and choose the file from (4)
    • Click “OK”

Now you can try some queries.

  1. To see how much money was spent from each account
  2. SELECT account, out

    To get a pie chart,

    • From the menu, select Chart > Pie
    • Click check box for “out”.
    • Click “OK”
  3. To check the day of week when the most money was spent
  4. SELECT dayofweek(date), out

  5. Why is most money spent on Wednesday
  6. SELECT description, out WHERE dayofweek(date) = "Wednesday"

  7. To check the day of week where money was spent on “Food”:
  8. SELECT dayofweek(date), out WHERE account = "Food"

  9. To check the break-up for account Food on Sunday
  10. SELECT description, out WHERE account = "Food" and dayofweek(date) = "Sunday"

  11. To see all the individual items
  12. GREP date, description, out WHERE account = "Food" and dayofweek(date) = "Sunday"

  13. To count how often you spend on cloths
  14. SELECT count(*) WHERE tolowercase(account) = "cloths"