Diffrence between Qlikviews and Business Objects(BO)?

Qlikviews Business Objects(BO)

Qlik View         BO
1. Qlik View has strong community                     1. Has poor Support
support and generally has vendor
   support
2. Does not require data warehouse,                  2. Requires Data Warehouse and a full
    time to go- line trends to be much                       scale long term project
   shorter than BO(QV claims ¼ of the
    time)
3. Has a pack  and go solution of for    3. Has no pack and go solution and very
    offline work and supports smart                          partial smart phone support(only for                      
    phones, iphones, ipads                                          web reporting tool)
4. Has both a web-only(AJAX) and                        4. Uses web browser as its only client
client application, the later tending                      application
    to provide significantly better
    performance

Schedule the report daily, monthly, weekly and involved in the BO report level testing?

Schedule the report daily, monthly, weekly and involved  in the BO report level testing                                                                                        
BO
a)Universe connection with Data Source
b)importing data from data source(tables)
c)create joins & contents
d) create hierarchies(year,month,quarter)
e) create more new objects, resolve the loops & same the universe in UNV format
f) check integrity and export to the repository
g)we can apply filters at universe level
Repository Domains:
1. Universe Domain
2.Document Domain
3. Security Domain
By the queries we will get data we will import data into designer
save the document and export to repository

Performance tuning in Qlik View?

Performance tuning in Qlik View:

Number of rows & columns:  we should be selective about what fields are to be included in the qlikview document and eliminate those fields which are currently not in used. We can load five years of data in QV instead of loading 10 years of data.

Number of Distinct Values: Fields with distinct values use the most space. Using count(distinct) forces QV to switch from using multicore to use only one core. Time stamps with mins or seconds can be truncated to store only date thus reducing the processing time.

Data Model: Qlik View can analyze multiple data sources but works most efficiently with Star Schema or Snow flake Schema, The Star Schema Consists of few fact tables possibly only one ,referencing any no. of dimension tables

User Interfaces:  Resource intensive expression like count(distinct) if() should be avoided. Set analysis should be used instead. Complex script should be done in script
rather than in charts/tables. Macros should be replaced by built in QV functions. Expressions which are used frequently in more than one chart/table should be stored in a variable which reduces the calculation time. Minimize the chart objects which are less important as chart expressions in minimized objects are not calculated.

What are the New Features in Qlikview Server?

New Features in Qlikview Server:
i) Content Sensitive Help
ii) Configurable LDAP
iii)audit logging by document
iv) Enable/Disable document download exporting and printing document and user
v) supporting task for QVD creation
vi) Distribution to Email with in a QVW document
vii) Alert Email to Document Administrators
Viii) License tracking
ix) Distribution and Reload Performance
x) Loop and Reduce
xi)Qlikview Management Console(QMC) user interface
xii) Reduction with log files
Xiii) Improved logging
xiv) QMC and QEMC are QMC
xv) Access point remake
xvi) Load Balancing Improved

What are the new features in QV 11?

a) Container Object- Grid Style
b)Granular Chart – Dimension Control
c)Actions like, clear filed, reset button
d)conditional enabling of dimensions and expressions
d)meta data
e)comparative analysis(multiple state selections)

What is Relative Path?

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 the difference between Straight Table and Pivot Table?

Difference between Straight Table and Pivot Table:
Pivot                                      Straight
1) Multi-dimensional with one or more        1) one dimension with multiple
 Measurements                          measurements
2) Displays Sub Totals                       2) do not display sub totals
3) Pivot table will show cross table              3) can’t show cross table

What is the use of Extended Interval Match function()?

Extended Interval Match function(): It is used for slowly changing dimensions

What is the use of Interval match function()?

Interval match function(): it is use generate data buckets of different sizes.

How many types of Charts? And uses of Charts?

Charts and Uses:
1. Bar Chart: Comparison of similar measurements
Ex.  a) Actual vs budget- money to money. Quarter to Quarter
       b) Time to Time
      c) Top N- categorized values(sales reps, customers etc)
avoid: comparisons with different units( $ and Qty)
2. line chart: measurements to follow its moments or comparisons among items
Ex. a) Performance trends- amount of moment over time
      b) Two Dimension comparisons- Annual comparisons over month
3. Combo Charts: Comparisons for multi measurements
Ex. Two measurements- currency amount and quantity or amount percentage
two axis- different measurements on left and right axis
two or more axis: split axis horizontally
4. Radar chart: comparisons of high level groups
one or two measurements- sales and profit
avoid- a dimension with many values
5. Guage chart: Ratio of measurements
a)Percentages- margin,quota achieved, year-tot
b) Date vs last YTD.
Avoid: actual amounts
6. Mekko chart: Data using variable width bars
a) 3D measurement chart- Amount, Quantity and no. of customers
b) market analysis.
7. Scatter Chart: Measurement acts as dimensions(3D Chart)
a) 3D measurement chart- Amount, Quantity and no. of customers
b)map chart- see sales on Geographical map
8.Grid Chart: 2 or 3 Dimensions with a measurement
a)multi-cross dimensional measurements
b)amounts over- region and product and over time
9.Pie Chart: Visual Distribution measurements
Ex.a) what contributes how to the whole- regional sales
     b)yes/no analysis
10. Funnel chart: Dimension that contain an expiration time line
Ex.a)how much is the most aging element
     b)Sales opportunities
    c)Product Inventory Expressions
11.Block chart: Distribution measurements within multi dimensions
Ex.a) what contributes how to whole and within each segments
     b)sales contribution per country
12. Straight Table: one dimension with multiple measurements
Ex.a)KPI overview- cyclic group dimensions with sales Qty , margin
     b) sort in any no of columns(no grouping)
13. Pivot table: multi dimensions with one or more measurements
    a) grouping of dimensions
    b) Dimensions across the table and displaying sub totals
First sorted value: It returns the first value of expression sorted by corresponding
sort weight. Sort weight should be a numeric value.
Uses: a) Get the latest field value based on time stamp
           b) bigger customer for each product category
c) Find the min/max values and extract related field
d) Compare highest and second value
e)look up min/max value with in range

What is Cluster.?

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)

What is Interval Match?

The interval match prefix to load or select statement is used for linking discrete numeric values to one or more numeric intervals
Ex. Intervalmatch(field)(load statement/select statement)

Difference between QVD and QVW?

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.

What are the layers in QV?

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.

What are the differences between Pivot table and straight table?

pivot data is grouped, partial sums can be shown in pivot table but not in straight table

Have you used macros in your application? What you have used?

we can use macros for various things
a)we can call the macro to reload the application
b)we can call the macro to create objects

Which QV object has only expression, no dimension?

List box, guage chart

How many dimensions can be used in bar chart.?

two

What is Mini chart?

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: sparklines, line with dots, dots, bars or whiskers we can set color also

What is Trellis chart?

Trellis:  open the Trellis setting in chartproperties , you can create an array of charts based on first dimension any type of bitmap chart can be made into trellis display.
a)We can enable trellis chart
b)Enable secondary Trellis Dimension
c)we can give no of columns to display in chart

What type of charts did you used?

Bar chart, line chart, combo chart, guage chart, scatter chart, grid chart, pie chart, funnel chart etc.

What type of data did you used?

flat files, excel, QVD’s etc

How do you bring data into QV? Explain the script?

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;

What type of data connections do you use?

ODBC, OLEDB, SAP connectors

QV provides a tool for getting a snapshot view of your table what is it? How it is helpful?

Table Viewer: we can see no of tables and associations and by right click-preview we can see data.

What is Set and Let ?

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 Variablename = String.
      Let variablename= operation.

What is cross table?

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, data field[ in])(load/select statement)

If server crashes then how do you check behind it or error log where you will find that log?

c:\programdata\Qliktech\webserver\log

What is difference between QV Server and Publisher?

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.

Types of CALS how do you assign them?

To connect a Qlikview server (QVS) each client needs a CAL(client access license) The CAL’s are purchased with Qlikview Serverand 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:
1.Named User CAL:  Named  CAL  can access all the documents
2.Document CAL: Document CAL can access particular document
3.session CAL: A session allows any user identified or anonymous/unidentified on one QV client to access many QV documents as may reside on the server
4.Usage CAL: allows any user to access only one QV document residing on the server

Difference between RDBMS and Associative Data Model.?

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

What is Fact Constellation 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.

Difference between star schema and snow flake schema?

Star Schema: In a star schema, the fact table will be at centre and in connected to dimensional tables. The tables are completely in Denormalized 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 denormalized 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.

Explain Aggr function?

Returns a set of values of expression  calculated over dimension
Ex: Agg(sum(sales), country)

What is the use of Load statement.?

Load statement: 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

What is the use of Select Statement.?

Select Statement: The SQL select statement is used to identify fields and tables to load from the current database connection.

What is the use of Connect statement.?

Connect: The connect statement is used to establish a connection to the database through an ODBC or OLEDB interface.

What is NoConcatenation.?

NoConcatenation: if the two tables have same fields also NoConcatenate treats as separate internal tables.

What is Concatenation.?

Concatenation: If the two tables have different fields concatenation of the two tables can be forced with concatenation prefix.

What is Keep.?

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
1. Inner
2. Left
3. Right   Ex. Right Keep.

What is Join.?

Join: it joins the loaded table with an existing named table or last previously created logical table.
Join are of 4 types

1. Inner Join  
2. Outer Join  
3. Left Join 
4. Right Join

What is Circular reference/loops.?

Circular  reference/loops:   There are more than one path of association between two fields below are the ways to remove.

1. Alias 
2. Qualify 
3. Link table (join) 
4. Concatenation.

What is Synthetic Key.?

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

1. Join 
2. Alias 
3. Concatenated key 
4. Link table 
5. Qualify

What is mapping load and apply map()

Mapping Load: The mapping prefix is used on a load or select statement to create a mapping table, these tables are different from other tables. They will be stored in separate area of memory and used as mapping tables during script execution. After execution they will automatically drop.

Ex. Mapping (Load Statement/Select Statement)

Apply Map: used for mapping data from one source to another at load time.

Ex. Applymap(‘Mapname’, expr,[default expr])