• Home »
• Blog »

Question.1 What is QlikView Server (QVS) and Publisher? Answer: QlikView server hosts all the QlikView documents, users and objects. QlikView server is accessed by QlikView management console. QlikView publisher is a component of QVS and is used for content management, access, data reduction and distribution. A separate license is required..

Question.1 What is calculated dimension? Answer: Charts in QlikView require dimensions. Dimensions provide context to measure or expressions. Sometimes these dimensions exist in the data and sometimes need to be calculated. Such dimensions are called calculated dimensions. Calculated dimensions are created in the chart, by using “Add Calculated Dimension” or..

Question.1 How dimensions are displayed on a QlikView dashboard? Answer: List box and Multi box can be created on a dashboard to display dimensions. Question.2 What chart types are available in QlikView? Answer:  QlikView provides different kinds of visualization objects. Some of the charts which can be used are Bar..

Question.1 In an organization, data is updated monthly. Few thousand rows of data get added every month to the existing tables. How you will load this data so that most updated data is reflected in the dashboard? Answer: This data load can be done by creating an incremental load script…

Question.1 What is QlikView Server (QVS) and Publisher? Answer: QlikView server hosts all the QlikView documents, users and objects. QlikView server is accessed by QlikView management console. QlikView publisher is a component of QVS and is used for content management, access, data reduction and distribution. A separate license is required..

Question.1  Why and how QVDs are used ? Answer: It is faster to read data from a QVD file. In QlikView script, data can be extracted from the table and stored in a QVD file. Use multiple QVD files to create the efficient data model. Create dashboards by reading data..

Question.1  What is the difference between Star schema and Snow flake scheme ? Answer: In Star schema, Fact table is in the center and surrounded by dimension tables. Snow flake schema is similar to star schema. In Snow flake schema, dimension tables may be connected to other related dimensions. For..

Question.1  What is QlikView? Answer: QlikView is an in-memory Business Intelligence application. In-memory means data is loaded and queried from RAM. QlikView uses the associative technology. Tables having common fields are associated or linked. QlikView stores data at a granular level. Data is not pre-aggregated. Components of QlikView are QlikView..

Question.1 Can you use mapping without source qualifier? Answer:  Not possible, If source RDEMS/DBMS/Flat file use SQ or use normalizer if the source cobol feed.  Question 2.When do you use a normalizer? Answer:  Normalized can be used in Relational to denormilize data. [sociallocker] Question.3 What are stored procedure transformations. Purpose..