Are you afraid of using one of the most power QlikView or Qlik Sense functionalities, Set Analysis, to build powerful QlikView or Qlik Sense applications because its syntax is daunting? You are not alone!
This course will teach you step-by-step to master Set Analysis so that you can start writing advanced aggregation expressions in QlikView and Qlik Sense with ease!
You will learn basics of Set Analysis first and then dive into advanced Set Analysis concepts to leverage this powerful advanced aggregation functionality in your QlikView or Qlik Sense application.
Challenge 4.12: Exclusion operator
Create a Line chart that shows sales for all product categories except Condiments, Confections, Grains and Cereals.
Even if user selects any of those categories, it should be excluded
Hint: Use -= operator.
Note: Any coupon requests, please contact DV or Shilpan directly.
At Vertechs, our mission is to teach, learn and inspire. We teach QlikView and Qlik Sense and contribute to charity that educates underprivileged kids.
Vertechs means convergence of three focus points.
Our instructors have over 10 years of combined QlikView experience so our courses include their practical experience that can help students to learn and master QlikView quickly.
Deepak Vadithala (aka DV):
Shilpan is passionate about sharing QlikView knowledge. He has over 15 years of experience in business intelligence under his belt. Shilpan has broader experience in various verticals including finance, manufacturing, insurance and healthcare.
Shilpan is a certified Qlik 11 Developer and Designer.
Greetings! I am a certified QlikView developer and designer /Qlik Sense Data Architect with over 15 years of experience in Business Intelligence, data warehousing and various relational database management systems.
With incredible data growth -- both structured and unstructured -- businesses struggle to make sense of data. Business discovery tools such as QlikView and Tableau offer new opportunities to those who want to help an enterprise make insight driven decisions. That's my passion and that's my life long purpose.
I enjoy sharing my knowledge in the field of Business Discovery and visual data analytics at my blog. I have developed and implemented numerous QlikView applications for banking, health care and manufacturing.
My goal is to make you an awesome QlikView developer!
I am currently working as a Qlik/BI Architect and managing a team of Developers. I am recognised as a Qlik Luminary for the year 2014 and 2017. Co-Founded Qlik Dev Group and author of QlikShare. Previous top 20 Global QlikView Community contributor. And I am certified, Scrum Master (PSM). Currently, pursuing masters in Data Science from the University of London.
I have been building Data platforms and BI applications since 2005. I had worked on many successful QlikView, QlikSense and SQL Server implementations, right from the inception through the implementation and deployment. My experience and skills range from application development and UI design to system administration. I can work autonomously and directly with business stakeholders at all levels to define requirements; then develop, document, test and deliver end to end projects within existing project management/delivery frameworks.
I am certified QlikView Designer, Developer, Administrator and Scrum Master. Expertise in Clustering setup, data modelling, data analysis, ETL and data migration projects. I have experience in dealing with large datasets (billions of rows). Qlik specialist with many years experience on versions 8.5 to 12, and now Qlik Sense including Sense APIs. Created many extensions and published them on Qlik branch. Certified Designer, Developer, System Administrator and Qlik Sense Data Architect and known within Qlik as a subject-matter expert.
Data Science: Python, Pandas, Numpy and D3.js
Business Intelligence: QlikView, QlikSense, SSRS, SSIS and PowerBI
Database: SQL Server and Oracle
Big Data: Apache Hive and Apache Pig
Design: Photoshop, Illustrator and Coreldraw
Other: Advanced Excel, VBA, VB Script and Scrum Master
1. Investment Banking