4 What do you understand by the Snapshot View of a table?
By this option, we can see a number of tables and related associations.
1 How can you use Macros in your application?
We can use macros for various purposes, such as reloading the application and creating an object.
1 What are Dimensions?
Dimensions allow data examination from various perspectives.
4 What is Concatenation?
Concatenation means a sequence of interconnected things, i.e., any columns or rows that are related to each other can be connected through concatenation.
5 What type of data do we use generally?
We use flat files, Excel files, QVDs, etc. as data.
2 What are the new features in QV 11?
Container object, granular chart dimension control, actions like clear filed, metadata, etc. are some of the new features in QV 11.
3 How can you optimize a QV Application?
A QV application can be optimized by creating QVDs for data. When the complete QVW application is changed into a QVD, then this QVD will be stored in the RAM.
4 What do you understand by the term ‘CAL’ in QlikView Server?
Every client needs a CAL to get connected with Qlikview Server. CALS are taken up with QlikView Server and tied up with the server serial number.
3 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.
2 Explain Join and its types.
Join is used to convert the given data, and whenever we use joins for converting data it is known as data merging. It has many types: a. Left join b. Right join c. Inner join, etc.
Define Apply Map.
Apply map is used to add fields to tables with the help of other tables. It can be used as a join.
Give your career a big boost by taking up our QlikView Training now!
Explain Set Analysis in QlikView.
Mostly used in aggregated functions like sum (year), avg, max, min, etc., set analysis is used to define a set (or a group) of data values.
What is a Pivot table?
A pivot table is better at the time of grouping. We can also show a pivot table like a cross table, which is a beneficial feature. However, there is a disadvantage with pivot tables, i.e., if we have to sort a pivot table, then we have to sort it first according to the first dimension, then to the next.
2 What are Modifiers?
Modifiers deal with the Fields name.
Example:
The above code returns the sales for the current selection, but the selection in ‘Region’ is removed.
Go through this insightful blog to learn Why QlikView is such a great Business Intelligence tool?!
5 What is QlikView Comparative Analysis in the QlikView Developer platform?
Business users can quickly gain new insights when analyzing their information in QlikView, with its 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.
Watch this extensive video on QlikView Training:
| 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 |