Department of Agriculture and Fisheries

QFish

User-Customised query

User-Customised query

Configuration

Columns
[Region]
Rows
[CalendarYear]
Measures
[DiscardNumber]
[Tonnes]
[Days]
Sorting

Filters

[CalendarYear]
Included: 2018
[FishingMethod]
Included: Net
[SpeciesGroup]
Type: Excluded
Caption: Species Group
Hierarchy: [Species].[Species Group]
Field Hierarchy: [Species].[Species Group].[Group] - [Species].[Species Group].[Species]
SortValues: Adult Eel, Barramundi, Beche de mer, Black jewfish, Bream, Bugs, Catfish, Cod and Groper, Coral Trout, Crab, Dart, Emperor, Flathead, Garfish, Glass Eel/Elver, Grunter, Jewfish, Kingfish, Lobster, Lobster - champagne (red), Mackerel, Mantis shrimp - unspecified, Marlin, Mullet, Mulloway, Nannygai, Other, Pearl perch, Prawn, Redthroat Emperor, Scad, Scallop, Shark,
Children:
Value: [a hound shark]
Value: [a wedgefish]
Value: Australian sharpnose shark
Value: Banjofish
Value: Bigeye sixgill shark
Value: Blacktip reef shark
Value: Blacktip whaler shark
Value: Blacktip whalers
Value: Blind Shark
Value: Colclough's Shark
Value: Creek whaler
Value: Eagle ray
Value: Endeavour Dogfish
Value: Giant shovelnose ray
Value: Greeneye dogfish
Value: Grey carpet shark
Value: guitarfish
Value: Guitarfishes - shovelnose unsp
Value: Hammerhead shark
Value: Milk, Sharpnose & Hardnose Sharks
Value: Nervous shark
Value: Oceanic whitetip shark
Value: Pigeye & Bull Sharks
Value: Ray - blue spotted sting
Value: Ray - cowtail sting
Value: Ray - eastern fiddler
Value: Ray - manta
Value: Ray - spotted eagle
Value: Ray - sting unspecified
Value: Ray - white spotted guitarfish
Value: Shark - angel unspecified
Value: Shark - australian blacktip
Value: Shark - Blacktip Whalers and Graceful
Value: Shark - blue whaler
Value: Shark - bronze whaler
Value: Shark - bull
Value: Shark - cat
Value: Shark - dusky
Value: Shark - eastern shovel nose
Value: Shark - epaulette
Value: Shark - fins unspecified
Value: Shark - fossil
Value: Shark - graceful
Value: Shark - grey nurse
Value: Shark - grey reef
Value: Shark - gummy
Value: Shark - hardnose
Value: Shark - lemon
Value: Shark - leopard
Value: Shark - mako
Value: Shark - milk
Value: Shark - pigeye
Value: Shark - sandbar
Value: Shark - school
Value: Shark - silky
Value: Shark - silver tip
Value: Shark - Snaggletooth and Weasel
Value: Shark - sorrah
Value: Shark - spinner
Value: Shark - tawny
Value: Shark - tiger
Value: Shark - unspecified
Value: Shark - weasel
Value: Shark - whaler unspecified
Value: Shark - white cheek
Value: Shark - white tip reef
Value: Shark - wobbegong
Value: Shark ray
Value: Sliteye Shark
Shell, Snapper, Squid, Stout Whiting, Surgeonfish, Sweetlip, Tailor, Teraglin, Threadfin, Trevally, Tropical Snapper and Sea Perch, Tuna, Unknown, Whiting, Wrasse,
[Hidden Field's Headers]
Hidden Fields
  • Expand
    Measures
    • Expand
      Catch
      • DiscardNumber
      • Kilograms
      • Tonnes
    • Expand
      Effort
      • Days
      • Licences
  • Expand
    Fishing Method
    • FishingMethod
  • Expand
    Logbook Grid
    • Grid
  • Expand
    Logbook Type
    • LogbookType
  • Expand
    Region Hierarchy
    • Region
  • Expand
    Species
    • CAABCode
    • Species
    • Species Group
  • Expand
    Time
    • CalendarYear
    • FinancialYear
    • Month
[Filter Area Headers]
Filter Area
FishingMethod
[Filtered]
Species
Species Group[Filtered]
[Row Area Headers]
Row Area
CalendarYear
[Filtered]
[Column Area Headers]
Column Area
Region
[Data Area Headers]
Data Area
DiscardNumber
Tonnes
Days
Update

Helpful Hints

Predefined queries can be customised to meet your specific data needs. For example to look at the catch of a Spanish mackerel, click on the down arrow for Species Group; click on the “tick” for show all and then locate mackerel and expand by clicking on “+”  then click in the square adjacent to Mackerel – Spanish.  Then click OK.  The data will be updated to show the catch of Spanish mackerel. You can select multiple species by this method.

Annual Queries: Basic queries that display catch and effort by Calendar Year. Annual queries cannot be mapped in their current form.

Note: To map the query select the Map tab above.

Export Data: Once you have filtered the data to what you are interested in, you can export the data in a number of different forms including Excel.

Custome Query: To change the query select the Customise tab. Drag the fields of your choice from Hidden Fields to one of the Filter, Row, Column or Data Areas in the PivotGrid Field List and click the Update button. To remove fields from your PivotGrid, drag the field back to Hidden Fields.

After selecting the fields you wish to display, the field buttons in the Pivot Grid often have a 'drop down' arrow that you can use to select particular elements within the field, e.g. click the Species field to select the species you want to display.

To ensure you are extracting the most appropriate data for your needs, please visit the Help Tab for more information.

v Page 1 of 1 (1 items)Prev[1]Next
FishingMethod[Filtered]
Species[Filter]
[Collapse]SpeciesGroup[Filtered]
-
Species
v Page 1 of 1 (1 items)Prev[1]Next