Qlikview with sql and sap business one dates

[csalcedoa]

I have a ODBC configured for bringme all data of SQL, i selected all fields that i need and shome info directly of DB.

I want configure this to show sales per month, year....

But this directly of database, not from a file....

Can someone helpme with this, i know i have do this in the script and i need dimmensions but im new with this.