by Sachin, on Jul 29, 2022 11:07:45 PM
Q1. What is QlikView?
Ans
Qlikview is a business intelligence tool which is used for converting raw data into knowledge. This software acts like a human brain that works on “association” and can go into any direction to search the answers.
Q2. Explain join and its types
Ans
Joins are used to merge data from different data sets into one. There are many types of joins-
- Left join
- Right join
- Inner Join
- Outer join
Q3. What is Trellis chart?
Ans
A trellis chart is a grid of charts. It is generally a repetition of a chart across a grid.
Q4. What is a Pivot table?
Ans
A pivot table is defined as a table of summary that is a table that allows you to extract the information from a large data set.
Q5. Compare QlikView with Tableau.
Ans
| Criteria | Tableau | QlikView |
| Performance | Uses a cubing technique that gives out results slower than QlikView | Faster than Tableau as it effortlessly combines all sizes of datasets |
| Interface | Comes up with a simple drag-and-drop interface that is easy, clean, and interactive | Has too many tools that are rarely used but certainly provide numerous ways for showcasing data |
| Suitable for | Provides dashboarding and rapid visualization | Offers departmental and enterprise-wide BI solutions |
| Product range | Has diverse products for varied uses | Has a single product for the entire BI solutions |
| Geographical maps | Building map visualization is easy with its in-built extension | Building map visualization takes longer since it needs scripting and an external extension for this |
| Tables | Weaker for tables | Very good for tables |
| Speed | Depends on RAM and the source database | Depends on RAM |
| Graphical inputs and changes | With easy drag and drop, graphical inputs are easy | For graphical changes, we will have to write the logic for it |
Q6. What is the difference between the Let and Set options in QlikView?
Ans
- Let: It assigns a variable to a value after assessing the expression.
- Set: It assigns a variable to a value without assessing the expression.
Q7. What is the difference between Keep and Join?
Ans
Join merges two tables to create one table whereas Keep implements Join logic on two tables but maintains them separately.
Q8. What is Fact Constellation Schema?
Ans
Fact Constellation Schema is a collection of multiple facts tables sharing common dimension tables. It is made up of several star schemas and hence also called galaxy schema.
Q9. What are the main features of Qlikview?
Ans
QlikView features are as follows
- Data visualization
- Dynamic BI Ecosystem
- Searching across all data
- Secure, real-time collaboration
- Interacting with dynamic apps, dashboards, and analytics
Q10. What are Incremental load and Resident load?
Ans
Qlikview Incremental load is used for loading new or changed records from the database, whereas resident load is a part of loading data which already present in the Qlikview application.
Q11. What are delimited files and why are they called CSV files?
Ans
Delimited files are text files in which data fields and data values are separated by commas, semicolons, and tabs, and that is why they are also called Comma Separated Values files. These files are saved with .csv extension.
Q12. Explain three tiers of QlikView Application
Ans
Three tiers of QlikView Application are:
- Tier I: Raw data is first loaded, and then QVD (QlikView Data) is created
- Tier II: QVD is transformed into a business login, and its need and data model is created.
- Tier III: Reading all QVD, which are there in Tier II, and one QVW is made.
Q13. What are the different types of data load in QlikView?
Ans
There are seven types of data load in QlikView are: 1) Load from files, 2) Resident Load, 3) Incremental Load, 4) Inline Load, 5) Add Load, 6) Buffer Load, and 7) Binary Load.
Q14. What is QVD file?
Ans
QVD file is defined as a collection of tables having data created in QlikView. It can be easily read or written in QlikView.
Q15. Explain Kurtosis() and Skew() functions
Ans
Kurtosis() and Skew() are two different types of statistical aggregate functions.
Kurtosis() function measures the peak of the curve, whereas Skew () measures the symmetry in a distribution curve.
Q16. Explain Architecture of Qlik view
Ans
The Qlik view architecture comprises of three main components, namely
- QlikView Server
- Qlik View Publisher
- QlikView Desktop.
Q17. What is QlikView annotation?
Ans
QlikView annotation helps users to engage in threaded discussions with content. If one user creates a note associated with the QlikView object, then other users can add comments on it.
Q18. What are the four types of CAL?
Ans
- Usage CAL
- Named CAL
- Document CAL
- Session CAL
Q19. Mention the types of authorization implemented at multiple levels in QlikView
Ans
- Data level
- Column level
- Sheet Level
- Chart level
- Document-level
Q20. List various services of the QlikView Server Environment
Ans
- QVS (QlikView Server)
- QVWS (QlikView WebServer)
- DSC (Directory Service Connector)
- QMS (QlikView Management System)
- QDS (QlikView Distribution Services)
Q21. Explain the concept of fuzzy search in QlikView
Ans
QlikView fuzzy search can find all the values according to the degree of resemblance to the string. The same result will be displayed even if the spelling is not match character by character.
Q22. What is the subset ratio?
Ans
The subset ratio is a ratio between the total numbers of distinct values found in the table compared to distinct values in the field whose subset ratio is needed.
Q23. What is the difference between QlikView and Qlik Sense?
Ans
| QlikView | Qlik Sense |
|---|---|
| QlikView is a hidden script. | Qlik Sense can be used anywhere in code. |
| ETL and OLAP are supported. | ETL and OLAP are not supported. |
| Supports SaaS/ multi-cloud platform. | It does not support SaaS/ multi-cloud platform. |
| Data mining or analytics is not possible. | Data mining or analytics is possible. |
Q24. What is QlikView data transformation?
Ans
Data transformation is the method of changing the existing data to a new data format. It also involves filtering or adding specific values to the existing data set.
Q25. Define fact constellation schema
Ans
Fact constellation schema is a logical database structure of data warehouse that can be designed with the help of denormalized Fact.
Q26. What is QIX Engine?
Ans
QIX is an interactive engine which coordinates and facilitates all the major functionalities in Qlik sense like:
- In-memory data calculations and data indexing.
- Self-service interactions.
- Start searching.
- Correlate with a scheduler, applications, and repository.
