Blog Archive

Theme images by Storman. Powered by Blogger.

Friday, August 5, 2016

Top 50 Qlikview Interview Questions With Answers.


Top 50 Qlikview Interview Questions With Answers. Qlickview Iterview Questions and Answers For Experienced. Most Frequently Asked Qlikview Interview Questions And Answers.

1.What kind of chart we use in Qlikview Admin?

We generally uses bar chart, line chart, combo chart, scatter chart, grid chart, etc.

2.Explain Set analysis in qlikview ??

It is used for set of groups. Mostly used in arrgeted function like sum (year)etc.

3.Define Trellis chart?

In Trellis chart we can create array of chart based on first dimension. Bitmap chart are also made of trellis display.

4.Explain Mini Chart?.What do you mean by sub reports and how we can create them?

With the help of Mini Chart we can set type of modes instead of values in table mode. We can also change the colors.

5.What is Pivot Table?

Pivot Table:

A pivot table is better at the time of grouping. We can also show pivot table like a cross table which is a beneficial feature. But there is one disadvantage of it which is if we have to sort a pivot table than we have to sort it first according to the first dimension then to the next.

6.Which graph we will use for two years difference sale ?

BAR Graph we will use.

7.What is Straight Table?

A straight table is much better at the time of sorting as compared to the pivot table as we can sort it according to any column as per our choice. But it is not good for grouping purpose.

8.How many dimensions we can use in Bar chart?

We can use only two dimension

9.Which Qlikview object has only expression and no dimension?

Gauge chart and list box have only expression and no dimension.

10.How we can use Macros in our application?

We can use macros for various purposes like for reloading the application and to create a object.

11.What do you understand by layers in Qlikview?

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

12.What is Dimensions?

Dimensions allow data examination from various perspectives.

13.Explain about Normalized Data?

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

14.What Is Star Sechma ?

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

15.What is Snowflaking Schema ?

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

16.Explain interval match?

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

17.Explain internal match function()?

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

18.What is Container ?

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

19.What do you understand by extended interval match function()?

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

20.what 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.

21.Explain joins and its types?

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:
a. Left join
b. Right join
c. Inner join, etc

22.What is Left Join?

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.

23.Define right join?

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.

24.Explain Inner Join?

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.

25.What are modifiers?

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.

26.Explain Identifiers Syntax?

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

27.Explain 3-tier architecture of Qlikview Application?

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.

28.How does Qlikview stores the data internally?

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.

29.Explain the restrictions of Binary load for a QlikView Developer?

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.

30.For a QlikView Administrator, differentiate between subset Ratio and Information Density.

Subset Ratio: It is used for easily spot problem in key field 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.

31.what is the use of Optimized Load?

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.

32.Differentiate between keep and joins?

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.

33.Define 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.

34.What is incremental load in Qlikview Architect?

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

35. Differentiate between set and let option in Qlikview?

Set: it assigns the variable without assesses the expression.
Let: it assigns the variable with assesses the expression.

36.Define Qlikview Resident Load.

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.

37.How we can optimize QV application?

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.

38.What is mapping load?

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

39.Define apply map.

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

40.What is concatenation?

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

41.Define NoConcatenation.

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

42.Define connect statement.

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

43.What do you understand by Fact constellation Schema?

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

44.What do you mean by RDBMS?

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

45What do you understand by the term CAL in Qlikview Server?

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

46.Differentiate between QV server and publisher?

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 the are loaded and distributed.

47.What do you understand by snapshot view of the table?

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

48.How we can bring data into qv?

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

49.How we can handle Early Arriving Facts.

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.

50.What type of data we generally use?

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

0 on: "Top 50 Qlikview Interview Questions With Answers."