Explore topic-wise InterviewSolutions in .

The DIFFERENCES are:

QlikView Server Enterprise Edition (EE) is available for customers looking to support a large number of users and integrate into enterprise environments. It includes features such as:

• Unlimited documents
• Integration with third party security systems
• Server clustering
• Small Business Edition (SBE) is designed to be used in smaller deployments.

It has the following limitations:

• For use only with Named and Document CALs
• Limited to 25 Named User CALs
•  Limited to 100 Document CALs
•  No support for additional servers

Only supports Windows Active Directory to handle security and access control Information Access Server (IAS) is an edition of QlikView Server designed to power public Internet SITES.

This edition:

• Includes the add-on QlikView Real Time Server
• Is licensed for uncapped number of user but limited to one QlikView document
• Must be set to ANONYMOUS mode only and authentication must be off
• Requires that the QlikView server be on the public Internet and publicly accessible
• Requires that the URL for accessing the SITE powered by the QlikView Server be publicly accessible
• Requires that no QlikView client (e.g., QlikView Desktop, Internet EXPLORER plug-in, Ajax) can access the QlikView Server (all user interfaces must be built by the customer manually or with QlikView Workbench)

QlikView Extranet Server (QES) is an edition of QlikView Server designed to extend QlikView functionality to external users via an extranet. QES:

• Requires authentication. Users must be external to the purchasing organization (customers, partners, etc.).
• Restricts server access to the Ajax client and mobile clients
• Provides the option to customize the QlikView application via the included QlikView Workbench
• Supports a maximum of 3 QlikView documents
• Supports session CALs and usage CALs only.

The differences are:

QlikView Server Enterprise Edition (EE) is available for customers looking to support a large number of users and integrate into enterprise environments. It includes features such as:

It has the following limitations:

Only supports Windows Active Directory to handle security and access control Information Access Server (IAS) is an edition of QlikView Server designed to power public Internet sites.

This edition:

QlikView Extranet Server (QES) is an edition of QlikView Server designed to extend QlikView functionality to external users via an extranet. QES:

QLIKVIEW offers the FOLLOWING FEATURES:

• Dynamic BI Ecosystem
• Data visualization
• Interacting with dynamic apps, DASHBOARDS and ANALYTICS
• Searching across all data
• Secure, real-time collaboration

QlikView offers the following features:

With the new annotations COLLABORATION object QlikView users can engage in threaded DISCUSSIONS about QlikView content. A USER can create notes associated with any QlikView object. Other users can then add their own commentary to create a threaded DISCUSSION. Users can capture snapshots of their SELECTIONS and include them in the discussion so others can get back to the same place in the analysis when reviewing notes and comments. QlikView captures the state of the object (current selections), as well as who made each note and comment and when, for a lasting record of how a decision was made.

With the new annotations collaboration object QlikView users can engage in threaded discussions about QlikView content. A user can create notes associated with any QlikView object. Other users can then add their own commentary to create a threaded discussion. Users can capture snapshots of their selections and include them in the discussion so others can get back to the same place in the analysis when reviewing notes and comments. QlikView captures the state of the object (current selections), as well as who made each note and comment and when, for a lasting record of how a decision was made.

KEY difference is in TERMS of the database used. QlikView offers a quite simple visualization that MATCHES the MS excel FILTERING. SAS is useful in case of Meta data while SPSS is good for analysis.

In comparison of the above three, QlikView is most user friendly and fast in terms of generating diverse dashboards/templates.

In terms of calculations, ADVANCED statistics options are limited in QlikView.

For market research and analysis SPSS has direct facility algorithms.

Key difference is in terms of the database used. QlikView offers a quite simple visualization that matches the MS excel filtering. SAS is useful in case of Meta data while SPSS is good for analysis.

In comparison of the above three, QlikView is most user friendly and fast in terms of generating diverse dashboards/templates.

In terms of calculations, advanced statistics options are limited in QlikView.

For market research and analysis SPSS has direct facility algorithms.

New optional settings within QLIKVIEW MANAGEMENT Console enable ADMINISTRATORS to more effectively audit user interactions. Administrators can audit QlikView usage not only at the SYSTEM level (the entire QlikView SERVER), but down to the document level.

New optional settings within QlikView Management Console enable administrators to more effectively audit user interactions. Administrators can audit QlikView usage not only at the system level (the entire QlikView Server), but down to the document level.

QlikView 11 delivers MOBILE functionality for APPLE iOS and Android TABLETS and smartphones. QlikView supports Android tablets when the following conditions are met:

• QlikView Server version 10 SR3 or later
• The native browser, not a downloaded one
• Currently our HTML5 web apps support only Apple and Android handhelds. Because many Black Berry are OLDER devices that don’t fully support HTML5 (and many are non-touch), we don’t have a web-based solution for them at this time.

QlikView 11 delivers mobile functionality for Apple iOS and Android tablets and smartphones. QlikView supports Android tablets when the following conditions are met:

BUSINESS users can quickly gain new kinds of insight when analyzing information in QlikView, with new COMPARATIVE analysis options. QlikView APP developers can now create multiple selection STATES in a QlikView app; they can create graphs, tables, or sheets based on different selection SETS.

Business users can quickly gain new kinds of insight when analyzing information in QlikView, with new comparative analysis options. QlikView App developers can now create multiple selection states in a QlikView app; they can create graphs, tables, or sheets based on different selection sets.

QlikView 11 brings new levels of capability and manageability to the QlikView Business Discovery PLATFORM. In this release, we FOCUSED our investments on five value propositions:

• IMPROVE collaborative decision making with Social Business Discovery
• Gain new insights into opportunities and threats and relative business performance with comparative analysis
• Expand QlikView usage to additional devices, including smartphones, with mobile Business Discovery
• Enable a broad SPECTRUM of users to jointly develop QlikView apps with QlikView’s rapid analytic app platform CAPABILITIES
• Improve the manageability and performance of QlikView with new enterprise platform capabilities.

QlikView 11 brings new levels of capability and manageability to the QlikView Business Discovery platform. In this release, we focused our investments on five value propositions:

As the name suggests, QlikView is a combination of quick and CLICK and these features make it intuitive and easy to USE. Users can visualize data, search multiple data SETS, create ad hoc reports, and view patterns and trends in data that may not have been visible in other reports.

QlikView is

• Flexible – dashboards are web based and accessible from desktop computers and MOBILE devices
• Interactive – users are able to drill down and select particular data within charts or tables
• Usable – users can SEE large amounts of data effectively and efficiently
• Scalable – useful for multiple business processes at analytical, operational and strategic levels

As the name suggests, QlikView is a combination of quick and click and these features make it intuitive and easy to use. Users can visualize data, search multiple data sets, create ad hoc reports, and view patterns and trends in data that may not have been visible in other reports.

QlikView is

QlikView is the Business Intelligence tool used by the University of St Andrews. Data from different University systems is combined and presented in a single dashboard in an easy and understandable WAY.

QlikView dashboards at the University of St Andrews are built on the FOLLOWING principles:

• Dashboards MUST be effective to use
• Dashboards must support users in CARRYING out their tasks
•  Dashboards must provide the right kind of functionality
• It must be easy to LEARN how to use a dashboard
•  It must be easy to remember how to use a dashboard
• To use QlikView, you do not need to have technical expertise in information systems, just a willingness to learn how it can support you.

QlikView is the Business Intelligence tool used by the University of St Andrews. Data from different University systems is combined and presented in a single dashboard in an easy and understandable way.

QlikView dashboards at the University of St Andrews are built on the following principles:

We use flat FILES, excels, QVDS, ETC AD DATA.

We use flat files, excels, QVDs, etc ad data.

We can LOAD DATA from ODBC, OLEDB, SAP connectors , by select statements and we can also load files like EXCEL, word, etc. by using Table SYNTAX.

We can load data from ODBC, OLEDB, SAP connectors , by select statements and we can also load files like excel, word, etc. by using Table Syntax.

We USE ODBC, OLEDB, SAP connectors KIND of data connections.

We use ODBC, OLEDB, SAP connectors kind of data connections.

By this option we can SEE NUMBER o TABLES and RELATED associations.

By this option we can see number o tables and related associations.

QV Server is a program that is installed on computer with various CALS which ALLOW user to access QV Files on the server. Publisher is a program which manages CENTRALIZED control on our QV files and manages them how and when they are LOADED and DISTRIBUTED.

QV Server is a program that is installed on computer with various CALS which allow user to access QV Files on the server. Publisher is a program which manages centralized control on our QV files and manages them how and when they are loaded and distributed.

Every client needs a CAL to get CONNECTED with QLIKVIEW Server. The CALS are TAKEN up with Qlikview Server and tied with the server serial number.

Every client needs a CAL to get connected with Qlikview Server. The CALS are taken up with Qlikview Server and tied with the server serial number.

It stands for relational Database management System. It ARRANGES the DATA into respective COLUMN and rows.

It stands for relational Database management System. It arranges the data into respective column and rows.

It is a logical database structure of DATA WAREHOUSE . It is designed with the help of DE Normalized Fact..

It is a logical database structure of data Warehouse . It is designed with the help of De Normalized Fact..

It is USED to establish a connection to database with the HELP of ODBC or OLEDB INTERFACE.

It is used to establish a connection to database with the help of ODBC or OLEDB interface.

NoConcatenation prefix is used to force the identical TABLES as two SEPARATE INTERNAL tables.

NoConcatenation prefix is used to force the identical tables as two separate internal tables.

It MEANS sequence of interconnected things i.e. any column or ROW which is RELATED to each other can be connected through CONCATENATION.

It means sequence of interconnected things i.e. any column or row which is related to each other can be connected through concatenation.

APPLY MAP is used to ADD FIELDS to the tables with the HELP of other tables. It can be used as joins.

apply map is used to add fields to the tables with the help of other tables. It can be used as joins.

Mapping load is used to CREATE the mapping table that can be used for replacing FIELD VALUE and field names.

Mapping load is used to create the mapping table that can be used for replacing field value and field names.

It can be optimized by creating the DATA into QVDS. When complete qvw application is changed into qvd than this qvd will be store in the RAM.

It can be optimized by creating the data into qvds. When complete qvw application is changed into qvd than this qvd will be store in the RAM.

Resident LOAD is a part of loading data in Qlikview APPLICATION. It is USED for loading data in TABLES which is ALREADY loaded in Qlikview application.

Resident load is a part of loading data in Qlikview application. It is used for loading data in tables which is already loaded in Qlikview application.

Set: it ASSIGNS the VARIABLE without assesses the EXPRESSION.

Let: it assigns the variable with assesses the expression.

Set: it assigns the variable without assesses the expression.

Let: it assigns the variable with assesses the expression.

INCREMENTAL load is NOTHING but LOADING new or CHANGED records from the database. With the help of QVD files we can use incremental Load.

Incremental load is nothing but loading new or changed records from the database. With the help of QVD files we can use incremental Load.

Synthetic key is the key where TWO or more TABLES consists more than one common column between them is CALLED as synthetic key.

Synthetic key is the key where two or more tables consists more than one common column between them is called as synthetic key.

Keep and joins do the same FUNCTIONS but in keep creates the two tables WHEREAS JOIN only creates the one table. Keep is used before the load or SELECT STATEMENTS.

Keep and joins do the same functions but in keep creates the two tables whereas join only creates the one table. Keep is used before the load or select statements.

Optimized load is much faster and preferable especially for LARGE set of data. It is possible if N o transformation are MADE at the TIME of load and no filtering is DONE.

Optimized load is much faster and preferable especially for large set of data. It is possible if n o transformation are made at the time of load and no filtering is done.

Subset Ratio: It is used for easily spot problem in key field association.it is only relevant for key fields since they are present in MULTIPLE tables and do not SHARE the same value.

Information Density: It is the field which CONTAIN the percentage of ROW which contain the non-null value.

Subset Ratio: It is used for easily spot problem in key field association.it is only relevant for key fields since they are present in multiple tables and do not share the same value.

Information Density: It is the field which contain the percentage of row which contain the non-null value.

Binary Load can be USED for only one APPLICATION MEANS we can only read the DATA from one QVW application and moreover set scripts is also a RESTRICTION.

Binary Load can be used for only one application means we can only read the data from one QVW application and moreover set scripts is also a restriction.

QLIKVIEW STORES the DATA in QVD as QVD has data compression capability. Qlikview has BETTER performance than other BI because of its memory analytics approach.

Qlikview stores the data in QVD as QVD has data compression capability. Qlikview has better performance than other BI because of its memory analytics approach.

1. tier: Raw data is loaded and we CREATE QVD
2. tier: QVD is converted in BUSINESS LOGIN and the requirement of business and data model is created.
3. tier: Reading all QVD from 2-tier and we MAKE a single QVW.

1. 0- Represents the empty SET
2. 1- Represents the FULL sets of records
3. $-Represents the record of current SELECTION
4. $1-Represents the previous selection
5. $_1-Represents the next selection
6. Bookmark01-Represents the Bookmark name

Modifiesr DEALS with the Fields NAME.

For example: sum({$<Region=>}SALES)

Returns the sales for current selection, but with the selection in “Region” is removed.

Modifiesr deals with the Fields name.

For example: sum({$<Region=>}Sales)

Returns the sales for current selection, but with the selection in “Region” is removed.

Inner JOIN specifies that the join between the two tables should be inner join. The resulting table should CONTAIN the full data SET from both the SIDES.

Inner join specifies that the join between the two tables should be inner join. The resulting table should contain the full data set from both the sides.

Right join SPECIFIES that the join between the two tables should be right join, it uses before the WORD join. The resulting table only CONTAIN the COMBINATION among two tables with the full data SET from the second table.

Right join specifies that the join between the two tables should be right join, it uses before the word join. The resulting table only contain the combination among two tables with the full data set from the second table.

Left join specifies that the join between the two tables should be left join, it uses before the word join. The resulting table only CONTAIN the COMBINATION among two tables with the full data SET from the FIRST table.

Left join specifies that the join between the two tables should be left join, it uses before the word join. The resulting table only contain the combination among two tables with the full data set from the first table.

Join is used to CONVERT the given DATA and whenever we are USING joins for converting data its is known ad Data Merging.

It has many types:

• Left join
• Right join
• Inner join, ETC

Join is used to convert the given data and whenever we are using joins for converting data its is known ad Data Merging.

It has many types:

Container OBJECT;Granular CHART Dimension CONTROL; ACTIONS like, CLEAR filed; meta data,etc are the new features in QV 11.

Container Object;Granular Chart Dimension Control; Actions like, clear filed; meta data,etc are the new features in QV 11.

EXTENDED interval match FUNCTION() is used for SLOWLY CHANGING the dimensions.

Extended interval match function() is used for slowly changing the dimensions.

A container OBJECT is used to keep multiple charts. We can USE a container object to keep many charts in the same BOX.

A container object is used to keep multiple charts. We can use a container object to keep many charts in the same box.

Internal MATCH function is USED to generate DATA bucket of different SIZES.

Internal match function is used to generate data bucket of different sizes.

The internal match is PREFIXES with the load statement which is used for CONNECTING different NUMERIC values to ONE or more numeric INTERVAL.

The internal match is prefixes with the load statement which is used for connecting different numeric values to one or more numeric interval.

A SNOWFLAKE schema is a difference of the STAR schema. Snowflake is used to improve the presentation of PARTICULAR QUERIES.

A snowflake schema is a difference of the star schema. Snowflake is used to improve the presentation of particular queries.

The SIMPLEST form of dimensional MODEL, in which data is prearranged into facts and dimensions is KNOWN as Star SCHEMA.

The simplest form of dimensional model, in which data is prearranged into facts and dimensions is known as Star schema.

Well Structured Form of DATA, which DOESNT have any repetition or redundancy of data. It’s a kind of Relational data. It’s mainly USED in OLTP kind of stuffs Denormalized Data – It’s a WHOLE bunch of data without any relationship among themselves, with redundancy of data. It’s mainly used in OLAP kind of stuffs.

Well Structured Form of Data, which doesnt have any repetition or redundancy of data. It’s a kind of Relational data. It’s mainly used in OLTP kind of stuffs Denormalized Data – It’s a whole bunch of data without any relationship among themselves, with redundancy of data. It’s mainly used in OLAP kind of stuffs.

DIMENSIONS allow DATA examination from various PERSPECTIVES.

Dimensions allow data examination from various perspectives.

The layer are basically SET on the sheet object properties layout where bottom, TOP, normal respective to the NUMBER -1,0 and 1.

The layer are basically set on the sheet object properties layout where bottom, top, normal respective to the number -1,0 and 1.