Yes the Qlikview connects to the new epos system via ODBC connections to the database tables stored on the server.
I understand that the layouts of reports cannot be matched exactly as per my old excel files and trying to replicate old files is proving to be very difficult. I have got this idea out of my head and am trying to produce reports with the same information but in easier to read formats and better formats where possible...... Just struggling a little at the beginning here as things arnt developing as quick as id like them to.
All Sales history has been migrated to the new system..... and for my own sanity I have a lot of the old sales history stored in excel files and microsoft databases that i could also use if need be...... but id like to keep all connections to the new system only (As the data and figures should be exactly the same)
Welcome to the world of Qlikview!
For what it's worth, I was in the same space about 6 months ago.
Have you worked through the tutorials / free online training?
This is an essential part of the learning curve.
However, you will also quickly need to get your head around things like data associations and SQL scripts, and these are not so well served by the learning resources mentioned above.
I do not have a programming background, but have found that some basic understanding of SQL script can go a long way!
Also, I have had a fantastic help from members of the Qlikview community.
I struggled initially, and received similar exhortations to persevere. I'm glad I did, and while not by any means an expert, have now a degree of confidence in my ability with the product.
As regards any specific issues you might have, why not try them out on the community? Or feel free to post your first few queries by private message.
Thanks for the advice.
I havent had chance to look at the tutorials yet - so this will be my task for the weekend. I will also get some literature to read on sql, I haven't really used Sql that much and have been using the scripts in qlikview and have had to work it out as and when i come to it..... This is one of the things that is slowing me down at the moment.
I guess its just patience and time and practice ! as with anything else in life.
Once again thanks and if I have any tricky questions, or get really stuck with anything then this communit will be my first point of call