Synthetic Keys: when two or more tables have two or more fields in common is called synthetic key. Below are the ways to remove synthetic keys Circular reference/loops: There are more than one path of association between two fields below are the ways to remove. Join: it joins the loaded table with an existing named table or last previously created logical table. Join are of 4 types Keep: it will not join two tables and they will be stored in QlikView as two separate named tables. Keep will always preceded by one of the prefix Ex. Right Keep. Concatenation: If the two tables have different fields concatenation of the two tables can be forced with concatenation prefix. No Concatenation: if the two tables have same fields also No Concatenate treats as separate internal tables The connect statement is used to establish a connection to the database through an ODBC or OLEDB interface. The SQL select statement is used to identify fields and tables to load from the current database connection. The load statement loads fields from a typed ASCII file from data defined in the script from previously loaded input table, from previously loaded field. From the result of the following select statements or by generating automatically Returns a set of values of expression calculated over dimension Ex: Aggr(sum(sales), country) Star Schema: In a star schema, the fact table will be at center and in connected to dimensional tables. The tables are completely in De normalized Structure. SQL queries performance in good as there are less number of joins involved. Data redundancy is high and occupies more disk spaces. Snowflake Schema: is an extension of star schema where the dimension tables are further connected to one or more dimensions. The tables are partially de normalized in structure. The performance of SQL queries is little bit less compared to star schema as more no. of joins are involved. Data redundancy is low and occupies less disk space compared to star schema. Fact Constellation Schema is describes a logical database structure of Data Warehouse or Data Mart. Fact Constellation Schema can design with collection of De Normalized Fact, Shared and conformed dimensional tables. Fact Constellation Schema is an extended Decomposed Star Schema. RDBMS: stands for Relational Database Management System. It organizes data into related rows and columns. It stores data in Tables having rows and columns. These tables are created and data retrieving using SQL Associative Database: The Associative Data Model is an alternative data model for database systems other data models are record based. To connect a QlikView server (QVS) each client needs a CAL (client access license) The CAL’s are purchased with QlikView Server and tied to the server serial number. A CAL is never transformed to the client but a client uses the CAL when connecting to the server. Cal Types: QV Server: is a program that is installed in a physical server (computer) with number of CAL’s these allow user to access QV files on the server. QVS controls the people who can access the documents on server using client access license (CAL). QV Publisher: is a program which allows you to maintain centralized control of all your QV files and to schedule when and how they reloaded and distributed. You can automatically reload files and distribute them to web access points or by email or intranet. You can do data reduction also. c:\programdata\Qliktech\webserver\log Cross table is common type of table featuring a matrix of values between two orthogonal lists of header data. To turn cross table into straight table use cross table prefix Ex. Cross table (attribute field name, data field name [ , n ] ) ( load statement | select statement ) Set: this command assigns the variable the text to the right of equal sign. Let: assigns the variable whereas Let command evaluates expression. Ex. Set Variable name = String Let variable name= operation ODBC, OLEDB, SAP connectors We can load data from ODBC, OLEDB, SAP connectors by connect, select statements and also we can load flat files like excel, word, xml etc… by using Table files syntax will be Directory: Load tables, from Ramsample.txt; flat files, excel, QVD’s etc… Bar chart, line chart, combo chart, gauge chart, scatter chart, grid chart, pie chart, funnel chart etc. Trellis: open the Trellis setting in chart properties, you can create an array of charts based on first dimension any type of bitmap chart can be made into trellis display. It is only available when the mini chart option has been selected in the expression page of straight table properties dialog. Opens a dialog for setting the properties of the mini chart, we can set mode type instead of values in table mode are: spark lines, line with dots, dots, bars or whiskers we can set color also Two List box, gauge chart We can use macros for various things Pivot data is grouped, partial sums can be shown in pivot table but not in straight table The layer are set on the sheet object properties layout where bottom, top, normal corresponding to the numbers -1,0,and 1 choose custom to enter value of your choice valid layer numbers are -128 to 127 QVW: A QlikView file saved in binary format having the default expression QVW. Also called Qlik View file .qvw file contains tables, charts script etc. QVD: a native Qlik View file format, A QVD file contains one data table, no layout and no security. It is basically a binary CSV file optimized for fast loading. The interval match prefix to load or select statement is used for linking discrete numeric values to one or more numeric intervals Ex. Interval match(field)(load statement/select statement) Cluster: for load balancing we have to install it with separate license when availability small business server only we can install Clusters. It will give high availability to the application (Zero Down time) Bar Chart: Comparison of similar measurements Avoid: comparisons with different units ($ and Qty) Line chart: measurements to follow its moments or comparisons among items Combo Charts: Comparisons for multi measurements Radar chart: Comparisons of high level groups Gauge chart: Ratio of measurements Avoid: actual amounts Mekko chart: Data using variable width bars Scatter Chart: Measurement acts as dimensions (3D Chart) Grid Chart: 2 or 3 Dimensions with a measurement Pie Chart: Visual Distribution measurements Funnel chart: Dimension that contain an expiration time line Block chart: Distribution measurements within multi dimensions Straight Table: one dimension with multiple measurements Pivot table: multi dimensions with one or more measurements First sorted value: It returns the first value of expression sorted by corresponding Sort weight. Sort weight should be a numeric value. Uses: Interval match function(): it is use generate data buckets of different sizes Extended Interval Match function(): It is used for slowly changing dimensions Relative Path: If we select Relative path, then we the work path is defined by directory statement. If it is not selected, the path of the QVW defines work directory. The work directory can be found in the system variable QVWORKROOT which should not be changed manually.What is Synthetic Key?
What is Circular reference/loops?
What is Join?
What is Keep?
What is Concatenation?
What is No Concatenation?
What is the use of Connect statement?
What is the use of Select Statement?
What is the use of Load statement?
Explain Aggr function?
Difference between star schema and snow flake schema?
What is Fact Constellation Schema?
Difference between RDBMS and Associative Data Model?
Types of CALS how do you assign them?
What is difference between QV Server and Publisher?
If server crashes then how do you check behind it or error log where you will find that log?
What is cross table?
What is Set and Let?
What type of data connections do you use?
How do you bring data into QV? Explain the script?
What type of data did you used?
What type of charts did you used?
What is Trellis chart?
What is Mini chart?
How many dimensions can be used in bar chart?
Which QV object has only expression, no dimension?
Have you used macros in your application? What you have used?
What are the differences between Pivot table and straight table?
What are the layers in QV?
Difference between QVD and QVW?
What is Interval Match?
What is Cluster?
Types of Charts? And uses of Charts?
What is the use of Interval match function()?
What is the use of Extended Interval Match function()?
What is Relative Path?
What are the new features in QV 11?
What is Synthetic Key?
What is Circular reference/loops?
What is Join?
What is Keep?
What is Concatenation?
What is No Concatenation?
What is the use of Connect statement?
What is the use of Select Statement?
What is the use of Load statement?
Explain Aggr function?
Difference between star schema and snow flake schema?
What is Fact Constellation Schema?
Difference between RDBMS and Associative Data Model?
Types of CALS how do you assign them?
What is difference between QV Server and Publisher?
If server crashes then how do you check behind it or error log where you will find that log?
What is cross table?
What is Set and Let?
What type of data connections do you use?
How do you bring data into QV? Explain the script?
What type of data did you used?
What type of charts did you used?
What is Trellis chart?
What is Mini chart?
How many dimensions can be used in bar chart?
Which QV object has only expression, no dimension?
Have you used macros in your application? What you have used?
What are the differences between Pivot table and straight table?
What are the layers in QV?
Difference between QVD and QVW?
What is Interval Match?
What is Cluster?
Types of Charts? And uses of Charts?
What is the use of Interval match function()?
What is the use of Extended Interval Match function()?
What is Relative Path?
What are the new features in QV 11?