Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Qlik Sense

You're reading from   Mastering Qlik Sense Expert techniques on self-service data analytics to create enterprise ready Business Intelligence solutions

Arrow left icon
Product type Paperback
Published in Mar 2018
Publisher Packt
ISBN-13 9781783554027
Length 514 pages
Edition 1st Edition
Languages
Arrow right icon
Authors (2):
Arrow left icon
Martin Mahler Martin Mahler
Author Profile Icon Martin Mahler
Martin Mahler
Juan Ignacio Vitantonio Juan Ignacio Vitantonio
Author Profile Icon Juan Ignacio Vitantonio
Juan Ignacio Vitantonio
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

Preface 1. Qlik Sense Self-Service Model FREE CHAPTER 2. Transitioning from QlikView to Qlik Sense 3. Security Rules: Attribute Based Access Control 4. Master Items in Qlik Sense 5. Qlik Sense on the Cloud 6. Qlik Sense Data Modeling 7. Best Practices for Loading Data in Qlik Sense 8. Advanced Scripting 9. Advanced Expressions in Qlik Sense 10. Overview of Qlik Sense APIs 11. Working with the Qlik Dev Hub 12. Coding in Qlik Sense 13. Creating Extensions in Qlik Sense 14. Integrating QS in Websites via Mashups 15. Other Books You May Enjoy

Advanced sample scripts

Creating a good script takes time and knowledge. In this section, I will show how a real script is put together in a real scenario for your reference. It is good to describe functions and best practices, but I believe showing everything come together in an example is even more valuable.

The following code example will show you in a very simple way how to:

  • Split your code into different sections
  • Create a simple stats table
  • Check if your source file exists and create one if it doesn't use control statements
  • Apply section access to the application

The sample script is split into sections that you can create in Script Editor.

For the script to work, you need to create a Create a new Connection in one Folder called Environment and another called Source.

In the Environment location, create a text file called Environment.txt with the following line of code...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image