Top Answers to Qlikview Interview Questions
1.Compare QlikView and Tableau
Criteria Tableau QlikView
Data integration Exceptional Good
Support for PowerPoint Available Not available
Visual Drilldown Good Very Good
Scalability Good Limited by RAM
2.What kind of chart we use in Qlikview Admin?
We generally uses bar chart, line chart, combo chart, scatter chart, grid chart, etc.
3.Explain Set analysis in qlikview ??
It is used for set of groups. Mostly used in aggregated function like sum (year), etc.Go through this insightful blog to learn why QlikView is such a great Business Intelligence tool.
4.Define Trellis chart?
In Trellis chart we can create array of chart based on first dimension. Bitmap chart are also made of trellis display.
5.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.
6.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.
7.Which graph we will use for two years difference sale ?
BAR Graph we will use.
8.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.
9.How many dimensions we can use in Bar chart?
We can use only two dimension
10.Which Qlikview object has only expression and no dimension?
Gauge chart and list box have only expression and no dimension.
11.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.
12.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.Go through this insightful Infographic to learn about the strengths of QlikView now.
13.What is Dimensions?
Dimensions allow data examination from various perspectives.
14.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.
15.What Is Star Sechma ?
The simplest form of dimensional model, in which data is prearranged into facts and dimensions is known as Star schema.
16.What is Snowflaking Schema ?
A snowflake schema is a difference of the star schema. Snowflaking is used to improve the presentation of particular queries.
17.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.
18.Explain internal match function()?
Internal match fuction is used to generate data bucket of different sizes.
19.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.
20.What do you understand by extended interval match function()?
Extended interval match function() is used for slowly changing the dimensions.
21.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
22.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
23.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.
24.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.
25.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.
1.Compare QlikView and Tableau
Criteria Tableau QlikView
Data integration Exceptional Good
Support for PowerPoint Available Not available
Visual Drilldown Good Very Good
Scalability Good Limited by RAM
2.What kind of chart we use in Qlikview Admin?
We generally uses bar chart, line chart, combo chart, scatter chart, grid chart, etc.
3.Explain Set analysis in qlikview ??
It is used for set of groups. Mostly used in aggregated function like sum (year), etc.Go through this insightful blog to learn why QlikView is such a great Business Intelligence tool.
4.Define Trellis chart?
In Trellis chart we can create array of chart based on first dimension. Bitmap chart are also made of trellis display.
5.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.
6.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.
7.Which graph we will use for two years difference sale ?
BAR Graph we will use.
8.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.
9.How many dimensions we can use in Bar chart?
We can use only two dimension
10.Which Qlikview object has only expression and no dimension?
Gauge chart and list box have only expression and no dimension.
11.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.
12.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.Go through this insightful Infographic to learn about the strengths of QlikView now.
13.What is Dimensions?
Dimensions allow data examination from various perspectives.
14.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.
15.What Is Star Sechma ?
The simplest form of dimensional model, in which data is prearranged into facts and dimensions is known as Star schema.
16.What is Snowflaking Schema ?
A snowflake schema is a difference of the star schema. Snowflaking is used to improve the presentation of particular queries.
17.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.
18.Explain internal match function()?
Internal match fuction is used to generate data bucket of different sizes.
19.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.
20.What do you understand by extended interval match function()?
Extended interval match function() is used for slowly changing the dimensions.
21.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
22.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
23.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.
24.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.
25.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.
