Hey guys - thanks for joining me in this Tuesday's edition of the Qlik Design Blog. Today I have provided a video that walks you through the Qlik Sense Data Load Editor and at the same time highlights a simple use case example where Qlik Load Script can come in handy....loading data from an Excel file, while looping through its multiple sheets.

 

As you may know Qlik Sense has a powerful visual data preparation interface to help you profile and prepare data for analysis, but did you know that Qlik also provides advanced scripting capabilities to help you transform and augment data as well as perform many other tasks, including those you may found in popular programming languages?

 

Some common examples include:

 

  • Incremental loading
  • Adding row and field level security: Section Access
  • Creating .QVD files
  • ...and more

 

Watch this brief video to learn about the Data Load Editor and see it in action, read on to learn about what else Qlik Script can do.

 

 

 

 

NOTE: To increase resolution or size of the video, select the YouTube logo at the bottom right of the player. You will be brought directly to YouTube where you can increase the resolution and size of the player window. Look for the 'settings' gears icon in the lower right of the player once at YouTube.

 

ALSO....

 

You can learn more about what other great things Qlik Script can do in these awesome blogs by our Jennell McIntire jmc:

 

 

...and many more. Stay tuned to the Qlik Design Blog on Fridays, where Jennell and team blog about many interesting Qlik design topics.

 

Can't see the video? - You can download the .mp4 attached to this post.

 

Samples files used in the video also are available.

 

Visual Data Preparation References:

 

 

Regards,

 

Michael Tarallo (@mtarallo) | Twitter
Qlik