Set Analysis – All the types

Courtesy:

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=_001

current selection. Calculate the sum of “Sales” (based on the current selection):

=Sum({$}Sales)

All Values.Calculate the sum of “Sales” (based on the current selection):
=Sum({1}Sales)

Based on everything that the current selection excludes.Calculate the sum of “Sales” (based on the current selection):

=Sum({1-$}Sales)

Based on the previous selection.Calculate the sum of “Sales” (based on the current selection):

=Sum({$1}Sales)
Based on the next selection. Calculate the sum of “Sales” (based on the current selection).

=Sum({$_1}Sales)

Based on the 2nd next selection:

=Sum({$_2}Sales)

Based on the 3rd next selection:

=Sum({$_3}Sales)

Based on the 2nd previous selection:

=Sum({$2}Sales)

Based on the 3rd previous selection:

=Sum({$3}Sales)

Based on the bookmark with the Id:

=Sum({}Sales)

Based on the current selection and the bookmark with the Id:

=Sum({$+}Sales)

Based on the current selection except those records belonging to the bookmark with the Id:

=Sum({$-}Sales)

Based on the intersection between the current selection and the bookmark with the Id:

=Sum({$*}Sales)

Simple Stored Procedure

USE MASTER_DB;
GO
CREATE PROCEDURE SP_GetEmployees_Details
@ENAME nvarchar(50),
@JOB nvarchar(50)

AS

SET NOCOUNT ON;
SELECT e.ENAME, e.JOB, d.DNAME,e.SAL,*
FROM EMP e,DEPT d
WHERE e.DEPTNO=d.DEPTNO
AND e.ENAME = @ENAME AND e.JOB = @JOB
AND e.COMM IS NULL;
GO

EXECUTE SP_GetEmployees_Details N’BLAKE’, N’MANAGER’;
— Or
EXEC SP_GetEmployees_Details @ENAME = N’BLAKE’, @JOB = N’MANAGER’;
GO
— Or
EXECUTE SP_GetEmployees_Details @ENAME = N’BLAKE’, @JOB = N’MANAGER’;
GO

Data Services features

Data Services features
Instant traceability with impact analysis and data lineage capabilities that include the data quality process
Data validation with dashboards and process auditing
Work flow design with exception handling (Try/Catch) and Recovery features
Multi-user support (check-in/check-out) and versioning via a central repository Administration tool with scheduling capabilities and monitoring/dashboards Transform management for defining best practices
Comprehensive administration and reporting tools
applications (for example, SAP)
databases with bulk loading and CDC changes data capture
files: comma delimited, fixed width, COBOL, XML, Excel