6 Replies Latest reply: Oct 11, 2011 7:57 AM by Kamal Naithani RSS

    Qlikview Questions: Need answers plz!

    Subin Thomas

      1) which are the objects to perform results based on current record selections?

      Can you choose which are the right answers from the below options?

           a. Listbox

           b. Pivot

           c. Set analysis

           d. Combo Chart

           e. Input box.

       

      2) In memory________does the following?

           a. Data loading

           b. Data resides in server Ram and calculation performed there.

           c. faster access to data

           d. Data cleaning.

       

      3) RAD consists of this as one of the step?

           a) Locate the data source

           b) create and execute load script

           c) place object on sheet

           d) start using application

           e) all

       

      4) Charts and Graphs are generated

           a) On the fly

           b) On demand engine

           c) by Query

           d) On schedule

           e) by UI

       

      5) Which helps to load data entered through scripts

           a)Load...from

           b)Load...select

           c)Load...autogenerate  

           d)Load...inline

           e)Load...resident

       

      6) a funnel is

           a) an object to filter

           b) an object to cleanse

           c) an object to display in the different dimentions

           d) a chart

           e) all

       

      7) This is a way to eliminate identical keys in the tables of qlikview data structure?

           a) using synthetic key

           b) loose coupled tables

           c) circular reference

           d) renaming the fields

            e) dropping identical keys from table viewer

       

      8) What is the use of current selection box??

       

      9) Data reduction in Qlikview document is dependent on initial data reduction on section access??

           a) True

           b) False

       

      10)The following securities can be implemented in Qlikview.

           a)SSO/NT

           b)sheet

           c)Object

           d)SSO/NT + data level

           e) All

       

      11) Data reduction is to hiding some data from the user through section access??

           a) True

           b) False

        • Qlikview Questions: Need answers plz!

          1. (c)

          2. (c)

          3. (e)

          4. (e)

          5. (d)

          6. (d)

          7. (d)

          8. sows current selection in the application.

          9. (b)

          10. (e)

          11. (a)

          • Qlikview Questions: Need answers plz!
            Subin Thomas

            Can anyone please justify the ansers with explanation for the above question?

              • Qlikview Questions: Need answers plz!
                Kamal Naithani

                1. (c)...set analysis is the dyanamic process used for getting the current values. We can compare the dyanamic result for the current selection using set analysis in qlikview.But all the ther will show static result

                2. (b)...I think in qlikview all the data is in ram and calculation is done there ,that is why it is so fast

                3. (e)....sometimes also known as DAR ie dashboard analytics report ie the basic method for getting the front -end design in qlikview.

                4. (e)

                5. (d)By using Inline we can generate the  data in script..

                example

                LOAD * Inline [

                Month,Quarter

                1,Q1

                2,Q1

                3,Q1

                4,Q2

                5,Q2

                6,Q2

                7,Q3

                8,Q3

                9,Q3

                10,Q4

                11,Q4

                12,Q4 ];

                It will give the quarter that we have generated.

                 

                6. (d)

                7. (d) renaming the field is best solution for this.....because we can use this field further so we cannot comment that.

                8. It shows the current selection of all the list box in the sheet

                9. (a)

                10. (e)

                11. (a)

              • Qlikview Questions: Need answers plz!
                Kamal Naithani

                1. (c)...set analysis is the dyanamic process used for getting the current values. We can compare the dyanamic result for the current selection using set analysis in qlikview.But all the ther will show static result

                2. (b)...I think in qlikview all the data is in ram and calculation is done there ,that is why it is so fast

                3. (e)....sometimes also known as DAR ie dashboard analytics report ie the basic method for getting the front -end design in qlikview.

                4. (e)

                5. (d)By using Inline we can generate the  data in script..

                example

                LOAD * Inline [

                Month,Quarter

                1,Q1

                2,Q1

                3,Q1

                4,Q2

                5,Q2

                6,Q2

                7,Q3

                8,Q3

                9,Q3

                10,Q4

                11,Q4

                12,Q4 ];

                It will give the quarter that we have generated.

                 

                6. (d)

                7. (d) renaming the field is best solution for this.....because we can use this field further so we cannot comment that.

                8. It shows the current selection of all the list box in the sheet

                9. (a)

                10. (e)

                11. (a)