Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interview Questions

Can any one tell some interview questions & answers in Qlikview.

please this is urgent and that will be help full


thanks

12 Replies
Not applicable
Author

Just follow discussions & understands sample documents from community . Those will be great to answer interview. 🙂

Bhushan N

Not applicable
Author

Technical Questions I been asked so far for Qlikview Developer Jobs

1. What is the difference between Set and Let?

2. How many dimensions can be used in Bar chart?

3.Which Qlikview object has only expression, no dimension?

4.What is the difference between Concatenate Load and Join?

5. Incremental Load

6. Synthetic keys . How to remove them

7. What is Circular reference? How to avoid them?

8. Have you used any macros in your application? If so, what you have used it for.

9. What is Set Analysis ( benefits of using it)? Why its called Set Analysis

10. Difference between Qlikview version 9 SR 6 and previous other Qlikview 9 versions?

11. What is the use of exists function in qlikview?

And there was more questions on database ( sql queries )......Hope this will help someone ,preparing for the interview

Not applicable
Author

Hi

i want to know answer for this question

which qlikview object has only expression ,no dimension

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

It should be Gauge Chart.

Gauge Chart doent Contain dimesion as its used to displaying KPI.

Not applicable
Author

Hi Deepak

I think it must be "List Box". Infact it could be "Gauge Chart" also.

Thanks

Attitude

Not applicable
Author

Hi All

Have answered most of the questions(Most of them are copied from the reference manual :-)). But it will be helpful for someone who need the most. Few not yet answered requesting someone to give answer for that.

1. What is the difference between Set and Let?

Ans:

Set:

Script variables are entities that can be assigned any text or numeric value. When used, the variable is substituted by its value. Variables can be used in the script for macro expansion and in various control statements. This is very useful if the same string is repeated many times in the script, e.g. a path.

set variablename = string


Let:

The let statement has been created as a complement to the set statement, used for defining script variables. The let statement, in opposition to the set statement, evaluates the expression on the right side of the ' =' before it is assigned to the macro variable.

let variable = expression


2. How many dimensions can be used in Bar chart?

Ans:

Two

3.Which Qlikview object has only expression, no dimension?

Ans:

List Box, Gauge Chart

4.What is the difference between Concatenate Load and Join?

5. Incremental Load

Ans:

Incremental load is a very common task in relation to data bases. It is defined as loading
only the new or changed records from the database. The rest should already be
available, one way or another.

6. Synthetic keys . How to remove them

Ans:

Renaming,Concatanating the field by creating KEY field and use Qualify Statement

7. What is Circular reference? How to avoid them?

Ans:

A structure in the data model where the keys
between at least three tables form a circle. The
logic then inferred is usually ambiguous and the
circlular reference needs to be broken. QlikView
does this by setting one of the tables as loosely
coupled.

8. Have you used any macros in your application? If so, what you have used it for.

Ans:

We can use macros for various things as follows

1. We can all the macro to reload the application.

2. We can call the macro to create the objects.

3. ....

9. What is Set Analysis ( benefits of using it)? Why its called Set Analysis

Ans:

Sets can be used in aggregation functions. Aggregation functions normally aggregate over the set of possible records defined by the current selection. But an alternative set of records can be defined by a set expression. Hence, a set is conceptually similar to a selection.

A set expression always begins and ends with curly brackets when used, e.g. {BM01}.

10. Difference between Qlikview version 9 SR 6 and previous other Qlikview 9 versions?

11. What is the use of exists function in qlikview?

Ans:

exists( field [ , expression ] )
Determines whether a specific field value exists in a specified field of the data loaded so far. Field is a name or a string expression evaluating to a field name. The field must exist in the data loaded so far by the script. Expr is an expression evaluating to the field value to look for in the specified field. If omitted, the current record’s value in the specified field will be assumed.

Thanks

Attitude

Not applicable
Author

Hi All

Adding to the list of questions can some please answer this as well. It will be very helpful for everyone.

1) What is BI ?.

2) Qlikview vs SAP BO or Cognos .

3) What do you mean by In Memory BI tool ?. Advantage and Disadvantage.

4) ETL in Qlikview ?.

5) Security in Qlikview

6) QEMC and QMC

7) DMS and NTFS

😎 Features in QV 8.5 , QV 9 , QV 10

9) Challenges you faced during Implementation

10) Difference between AJAX and IE-Plug-in

11) IIS is able to use in QlikView 9 server

12) Difference between straight table and pivot table

13) Difference between grid chart and scatter chart

14) How to implement Dynamic Google map

Thanks

Attitude

Anonymous
Not applicable
Author

Few more in addition to above:-

1. What is data /dateIsland?

2. What is difference between keep and Join?

3. What is peek & previous function?

4. What is above & below function?

5. What are the KPI's have you used and what is that?

Best Regards,

Skumar

Anonymous
Not applicable
Author

4.What is the difference between Concatenate Load and Join?


Ans: Join and Concatenate can be used to tackle the same kind of situation, but there is a difference which should be understood.

Join will combine the rows where the key values matches, but OUTER keyword along with join also combines where key values doesn't match.

Concatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows from the two input tables.

Note: Concatenate can be forced even though there are no common field set in the two tables.