TechStuffy

How to Develop Qlik Sense Apps Stored Outside the Apps folder – Qlik Sense For Beginners

How to Develop Apps Stored Outside the Apps folder

This video will cover how to use the windows mklink command to develop your Qlik Sense apps from any folder.

The mklink command has others uses and is not restricted to being used with Qlik Sense but if you have started developing using the Qlik Sense Desktop you might think that…

TechStuffyBooks QlikView & Qlik Sense Trailer

[av_video src=’https://www.youtube.com/watch?v=uAAqpJWUIuA’ format=’16-9′ width=’16’ height=’9′] Welcome to my QlikView & Qlik Sense Channel. Here I will be creating tips on learning QlikView and Qlik Sense.

Please subscribe to be updated with new videos.

Video Training Courses: http://udemy.com/u/markodonovan

Find books samples at: http://techstuffy.com/downloads

Amazon Author Page: http://ww…

Qlik Sense Group By Clause – Qlik Sense for Beginners #15

[av_video src=’https://www.youtube.com/watch?v=t-_-4UpIDDM’ format=’16-9′ width=’16’ height=’9′] Qlik Sense for Beginners – http://techstuffybooks.com Grouping data: GROUP BY In this example we will show how you can group data for example, we can group the number of Employees by Gender.

The GROUP BY clause in Qlik is used in the same way as SQL.

To get the sample data and book samples go to h…

Qlik Sense Where Clause – Qlik Sense for Beginners #14

  Filter the data: WHERE Qlik Sense for Beginners – http://techstuffybooks.com

[av_video src=’https://www.youtube.com/watch?v=QAFCmGiyFXU’ format=’16-9′ width=’16’ height=’9′]

Using the WHERE clause in the Qlik Sense loadscript to Filter the data your are loading into your app.

In this example we are only reading the EmployeeIDs that are less than 10.

The WHERE clause can be used with SQL…

Qlik Sense Expressions – Qlik Sense for Beginners #13

[av_video src=’https://www.youtube.com/watch?v=4xBOLP2omAE’ format=’16-9′ width=’16’ height=’9′]

Qlik Sense for Beginners Book – http://techstuffybooks.com

Expressions in the Load Script

In this example I will show how to create a calculated field in the load script.

1. Go to the DLE. 2. In the example below we are using the IF statement to calculate convert the Gender field so that M is…

Qlik Sense Desktop and ODBC (Part2) – Qlik Sense for Beginners #12

[av_video src=’https://www.youtube.com/watch?v=XcHphbk4b4M’ format=’16-9′ width=’16’ height=’9′] Next we will show you how to connect to an ODBC data source using Qlik Sense Desktop and the ODBC Administrator tool. In this example we will connect to a Microsoft Access Database.

Sample data for the example: http://techstuffy.com/downloads

Qlik Sense for Beginners Book – http://techstuffybooks…

(via https://www.youtube.com/watch?v=XcHphbk4b4M)

Next we will show you how to connect to an ODBC data source using Qlik Sense Desktop and the ODBC Administrator tool. In this example we will connect to a Microsoft Access Database.

Sample data for the example: http://techstuffy.com/downloads

Qlik Sense Desktop and ODBC – Qlik Sense for Beginners #11

[av_video src=’https://www.youtube.com/watch?v=tPIXGsoavgc’ format=’16-9′ width=’16’ height=’9′] Next we will show you how to connect to an ODBC data source using Qlik Sense Desktop and the ODBC Administrator tool. In this example we will connect to a Microsoft Access Database.

Sample data for the example: http://techstuffy.com/downloads

Qlik Sense for Beginners Book – http://techstuffybooks…

Managing the Qlik Sense Data Model (Part2) – Qlik Sense for Beginners #10

[av_video src=’https://www.youtube.com/watch?v=JYQbNX4TPuI’ format=’16-9′ width=’16’ height=’9′] http://www.techstuffybooks.com – Qlik Sense for Beginners Book Once you have created the right links between your tables creating the charts\tables from that data is relatively easy.

In this video we will examine how Qlik Sense creates links between tables and how we can prevent Qlik Sense from…

Mark O’Donovan – Qlik Luminary, Class Of 2016

Hi Everyone,

Very proud day as it was announced I am now a member of the Qlik Luminary Class Of 2016.

I’m looking forward to an interesting year.

  The 2016 class features individuals from around the world who publicly share their passion and enthusiasm for Qlik and data discovery.

Through their contributions, they are an inspiration to the Qlik community and ecosystem.

  Here are some links to…

Managing the Qlik Sense Data Model (Part1) – #QlikSense for Beginners #9

[av_video src=’https://www.youtube.com/watch?v=CQ4z957wGFo’ format=’16-9′ width=’16’ height=’9′] http://www.techstuffybooks.com – Qlik Sense for Beginners Book

Once you have created the right links between your tables creating the charts\tables from that data is relatively easy.

In this video we will examine how Qlik Sense creates links between tables and how we can prevent Qlik Sense from…