Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Example ETL Scripts

Hi all,

I'm new to QV but have an extensive background in BI Development using Business Objects, MS SQL Server, Oracle and MySQL so am proficient and being able to 'reverse-engineer' scripts and understand the concepts within them and what they are doing if that makes sense.

Basically I have to learn QV as fast as possible due to the typical organisational situation of 'we-can't-give-formal training-but-learn-this-ASAP' .

My question is -> so I can learn QV as fast as possible, would you be able to upload some example ETL scripts that you have used in QV in the past ?

This would be extremely, extremely helpful.

Thanks,

Davydd

8 Replies
disqr_rm
Partner
Partner

I can share my experience of learning the most in one week.

Pick a mid-size project, hire a "good" consultant for one week and work with him/her on the project. In my experiece, 80% of the mid-size QV projects can be done in one week or so. And while working on the project with him/her, have on-site training for harlf a day or so on advance stuff.

I doubt that people will upload ETL scripts here. Reason is sensitive data, big file sizes etc. The best option for you would be ask your QlikView counterpart (or partner) you are workign with. He/she can provide you many examples on the topics you may have.

Hope this helps you.

Rakesh

Not applicable
Author

Thanks Rakesh,

I will be heavily working with a consultancy for this project however I wanted to be as up to speed as possible before I fly over to learn off them.

Maybe someone will post something otherwise I will learn (hopefully as much as possible) on the job.

rwunderlich

They are not complete ETL scripts, but the Qlikview Cookbook
http://robwunderlich.com/Download.html
has some examples of typical scripting tasks.

What type of source data are you working with? Subject (Finance, Ops, etc) & ERP name?

-Rob

johnw
Champion III
Champion III

I'm not so sure this is a good way to learn, but I don't see anything confidential in the script in the latest application I threw together, a shipping application. Nothing particularly interesting about the script. Just a straight load of data from QVDs. But it's attached, for what it's worth. And lest it confuse you, you don't write QlikView scripts as text files. You write it in a QlikView application. But the application DOES have confidential information, and it's huge, and I don't want to scramble it, and so on. So I'm just sending you the script.

I think you're best off going through the tutorial, and then just starting in on your real application. But I suppose everyone learns differently.

Not applicable
Author

Hey I actually downloaded the cookbook recently but I'm not able to view it as I currently only have the Personal edition until our server arrives etc.

Are you abnle to copy and paste the text or send me some text files with some scripts from the cookbook? That would be really really helpful!

thanks

Not applicable
Author

Hey I actually downloaded the cookbook recently but I'm not able to view it as I currently only have the Personal edition until our server arrives etc.

Are you abnle to copy and paste the text or send me some text files with some scripts from the cookbook? That would be really really helpful!

Oh yes, source data is media / affiliate information

thanks

Not applicable
Author

thanks to all who replied!

Not applicable
Author

Hi John

That shipping script is perfect - thanks!