11 Replies Latest reply: Jul 30, 2012 7:22 AM by Deepak Vadithala RSS

    Interview Questions

    Anil Konduri

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

      please this is urgent and that will be help full


      thanks

        • Interview Questions
          Bhushan Nirgude

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

          Bhushan N

            • Interview Questions

              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

                • Interview Questions
                  raghuma87

                  Hi

                  i want to know answer for this question

                  which qlikview object has only expression ,no dimension

                    • Interview Questions
                      Deepak Kurup

                      hi,

                       

                      It should be Gauge Chart.

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

                        • Interview Questions

                          Hi Deepak

                           

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

                           

                          Thanks

                           

                          Attitude

                            • Interview Questions

                              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

                                • Interview Questions

                                  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

                                  8) 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

                                  • Re: Interview Questions
                                    Shubham Kumar

                                    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.

                        • Re: Interview Questions
                          Shubham Kumar

                          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