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. … Continue reading Set Analysis – All the types

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 Continue reading Simple Stored Procedure

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, … Continue reading Data Services features