

{"id":39020,"date":"2018-11-23T13:00:26","date_gmt":"2018-11-23T07:30:26","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=39020"},"modified":"2021-12-07T11:19:47","modified_gmt":"2021-12-07T05:49:47","slug":"qlikview-interview-questions-and-answers","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/","title":{"rendered":"QlikView Interview Questions and Answers &#8211; Clear Basic Concept"},"content":{"rendered":"<p align=\"justify\">We have learned all QlikView Basic Interview Questions in <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-for-freshers\/\">part-1<\/a><\/strong>. In this part, we will cover all basic concepts with all these QlikView Interview Questions and Answers.<\/p>\n<p align=\"justify\">This article helps you to crack QlikView developer interview and many other.<\/p>\n<p align=\"justify\">No one can crack the Interview without knowing the basic concepts, through this QlikView Interview Questions and Answers, you can get all the basic and necessary information.<\/p>\n<p align=\"justify\">So, don&#8217;t waste your time and<a href=\"https:\/\/data-flair.training\/blogs\/qlikview-tutorial\/\"> start exploring QlikView<\/a> Interview Questions and Answers.<\/p>\n<h3 align=\"justify\">Commonly Asked QlikView Interview Questions and Answers<\/h3>\n<p>Following are the top QlikView Interview Questions and Answers, let&#8217;s discuss them:<\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.1. What are Aggregate functions?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/\">Aggregation functions<\/a> are the functions that aggregate or bundle your data present in the rows of the table. You can apply mathematical or statistical operations collectively on large data chunks using aggregate functions.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.2. What are the 6 different types of Aggregate functions?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Six types or categories of aggregate functions are; Basic, String, Counter, Advanced, Statistical and Financial Aggregate Functions.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.3. Explain min() and max() aggregate functions.<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">The min() aggregate function returns the minimum numeric value from the set of values evaluates.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">On the contrary, max() function returns the maximum numeric value from the set of data values evaluates. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.4. What is the difference between the string aggregate functions MinString(), MaxString() and FirstValue(), LastValue()?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">All four of these functions apply on the string values. The MinString() function returns the first text value form a column\/field irrespective of the order in which it loads. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Similarly, MaxString() returns the last text value form a field irrespective of the load order. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Like if the field in Months, then MinString() returns January and MaxString() returns December.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Whereas, FirstValue() returns the first value that was loaded (i.e. it follows the load order) and LastValue() returns the last value in load order.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-functions\/\">We recommend you to learn &#8211; A complete list of QlikView Functions<\/a><\/strong><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.5. What do you understand by Kurtosis() and Skew() functions?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Kurtosis() and Skew() are a type of statistical aggregate functions. Kurtosis() measures the peak of a frequency distribution curve.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"> Whereas, Skew() measures the symmetry in a statistical distribution curve. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.6. What does QlikView Aggr() function do?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">The Aggr() or Aggregation function will aggregate over the set of possible records defined by the selection and returns a value resulting from the calculation performed on the data set. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.7. Explain QlikView IntervalMatch() and Match() functions.<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-intervalmatch\/\">QlikView IntervalMatch()<\/a> function matches a value from one table with an interval or time value in another table. That is, you can compare the difference in time values in two tables. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">QlikView Match() function matches a string expression value with other relevant values. It is more like an advanced search which uses for filter the required data through script command. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.8. What are the two types of Match() function?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">QlikView Match() function is of two types; Match() and Wildmatch().<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">The difference between both is that in Match() function the entire string has to type\u00a0as it is for the system to search it. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Like, if you want to search the data in the filed Regions, then you must type the expression like,<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Match(Regions, \u2018Europe\u2019,\u2018South Asia\u2019). <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">But in the case of Wildmatch() full strings aren\u2019t to\u00a0type, instead of wild characters can use for searching. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Wildmatch(Regions, \u2018Eu*\u2019,\u2018S* As*\u2019)<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.9. What do you understand by Rangesum() function? How is it different from the Sum() function?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Rangesum function is used to calculate the sum of a selected set of data or a range of data. The Sum() function can\u2019t apply on a selected lot of data values but the whole of it. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Whereas Rangesum() can use according to your preferred set of data and can apply within other function expression and can return the sum of the expression as well.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.10. Discuss one scenario where you can use Rank() function.<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Let us suppose that a car company wants to know the performance of countries in sales. For this, they would want to rank the countries based on sales occurred in them. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">For this we will use <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-rank-function\/\">Rank() function<\/a> on the total of sales amount for each country. The expression would look something like this, Rank(sum(Sales_in_country)).<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"> This would rank the countries from highest to lowest based on total sales value for each. If Australia had sales of 10,00,000 it will rank 1<\/span><\/span><sup><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">st<\/span><\/span><\/sup><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">. Then if the USA had sales of 9,80,000 then it will rank 2<\/span><\/span><sup><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">nd<\/span><\/span><\/sup><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"> and so on.<\/span><\/span><\/p>\n<p align=\"justify\"><em>We recommend you to read QlikView Interview and Answer <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions\/\">Part &#8211; 3\u00a0<\/a><\/em><\/p>\n<h3 align=\"justify\">Scenario-Based QlikView Interview Questions and Answers<\/h3>\n<p>These are the latest QlikView Interview Questions and Answers, helps you to get updated.<\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.11. What is ETL?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">ETL is short for a data processing method i.e. Extract, Transform and Load. Data is extracted from the data source, transformed into user files and then finally loaded into QlikView for the users to use them<\/span><\/span><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.12. What is the difference between a list box and a multi box?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">A list box displays all the values of a single table field in the form of a list. It is used to make selections of data values convenient. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Whereas, a multi-box is a compressed table showing only the fields on display. You need to click on the Add sign to view data values of each field. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">So, the main difference between the two is that in list box you can only get one field displayed but in a multi-box all the fields can display.<\/span><\/span><\/p>\n<p align=\"justify\"><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-list-box-multi-box\/\">Refer this link to know QlikView List box and Multi-Box<\/a><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.13. What is a text box used for?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">A text box is used to display descriptive text to give information related to the data user is working with.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.14. What is a Mekko chart? Which sector are they most useful in?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Mekko charts represent data in the form of colored bars of varying sizes or width (according to the magnitude of data value it is representing).<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"> Such charts are used in business sectors specifically in market analysis.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.15. What is the fundamental difference between a block chart and a mekko chart?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Mekko charts represent data values as bars of varying sizes and width whereas block charts represent data values as blocks od varying areas. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.16. Explain Gauge charts.<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">A gauge <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-charts\/\">chart in QlikView<\/a> is used to display information like in a meter gauge. You can decide the highs and lows of values by looking at the gauge needle. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Gauge charts display single expression or data value and not the entire dimension. You can put in different expressions for calculating percentage etc. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">The needlepoint of the gauge changes as soon as you make any selection in the table.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.17. What is a QlikView Dashboard?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dashboard\/\">QlikView\u2019s dashboard<\/a> is a document\/sheet or collection of them consisting of different kinds of sheet objects containing the <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-data-load\/\">loaded data in QlikView<\/a>. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">A user can conduct analysis on the data by representing and visualizing it in different ways and types of sheet objects on the dashboard.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.18. What are the different components of a dashboard?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Charts, Input Boxes, Selection Boxes, Buttons, Texts or list box Objects, Notes &amp; Comments. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.19. What is the difference between SELECT and LOAD statements?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Both the statements are used to load data from external sources into QlikView. However, they are fundamentally different and are used in different situations.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">LOAD statement used to load data from all sorts of files, from previously loaded data, inline data, autogenerated data. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Whereas, SELECT statement use to load data from ODBC or OLE DB data sources. The statements using SELECT are not evaluated by QlikView but evaluates by the ODBC drivers or OLE DB providers. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.20. What are the operations that could perform on the data in a Transformation Wizard?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Data can transform in five ways in a <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/\">transformation wizard<\/a>,<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Garbage, Fill, Column, Unwrap, Rotate.<\/span><\/span><\/p>\n<p align=\"justify\"><em>Follow this link to know Frequently QlikView Interview Questions and Answers <a href=\"https:\/\/data-flair.training\/blogs\/latest-qlikview-interview-questions\/\">Part &#8211; 4<\/a>\u00a0<\/em><\/p>\n<h3 align=\"justify\">Advance QlikView Interview Questions and Answers<\/h3>\n<p>These are the QlikView Interview Questions and Answers for Experienced.<\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.21. What does the Garbage tab do in a transformation wizard?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">The garbage tab, use to delete the unwanted rows in a table. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.22. What function must you choose to add columns in a table?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">This can be done from the \u2018Column\u2019 function of the transformation wizard. Using this function, a new column can add into the table and values from pre-existing fields can enter in the newly added column.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.23. What does the Unwrap function do?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">The Unwrap function undo the operations performed by the Wrap function. The wrap function takes the bottom half of a table and puts it adjacent (on the right section) of the first half. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Whereas, the unwrap function takes this right section of the table and puts it back below the upper section of the table. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.24. What are the Dimensions?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">In a table, <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dimensions-measures\/\">Dimensions<\/a> are always the descriptive text values.<\/span><\/span> <span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">The fields with informative values like ID, product name, country, category are all Dimensions. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.25. What are Measures?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dimensions-measures\/\">Measures<\/a> are all the numerical values or fields in the table upon which mathematical calculations can perform.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.26. What is a Star Schema?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">A <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/\">star schema<\/a> is a way of representing a data model which has a central fact table to which individual dimension tables link. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">It is a relational database model which represents a multi-dimensional database. It calls as a star schema because the entity relationship diagram of the fact table and dimension table looks like a star.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.27. Why is the formation of a Synthetic key considered bad in QlikView?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">In QlikView, if there are several fields in common between two or more than two tables then a table containing the set of composite keys is made. This table is identified by a <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-synthetic-keys\/\">synthetic key ($<\/a><\/span><\/span><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-synthetic-keys\/\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"><i>Syn<\/i><\/span><\/span><\/a><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-synthetic-keys\/\"> key)<\/a>. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">However, this approach by QlikView to manage overriding fields consider as a sign of poorly designed data model.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"> The user must check for logical errors that in turn reflects into the script not making a good <a href=\"https:\/\/data-flair.training\/blogs\/best-practice-for-data-modeling-in-qlikview\/\">data model<\/a>. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.28. How can data generate automatically in QlikView?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">QlikView provides a feature called <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-autogenerate\/\">Autogenerate<\/a> which use for generate data using system\u2019s programming.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Using Autogenerate, QlikView\u2019s software creates data automatically following a few commands.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"> Such data which autogenerate create not load from an external source but create unique. Autogenerate might generate data like 20 random numbers, dates of 15<\/span><\/span><sup><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">th<\/span><\/span><\/sup><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"> week of the year, date and days from the\u00a0current date to the last of the year etc. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.29. What are the different types of tables in QlikView?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">There are different types of tables which can use to represent data in a tabular structure. The <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-table\/\">types of tables available in QlikView<\/a> are; Straight table, Pivot table, Mapping table, Cross table and a simple table sheet object. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">Q.30. What is a cross table? How is it different from transposing a table using a Rotate function?<\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">In a cross table, the rows and column switch places from the state they originally were in.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\"> In such a table the data values of rows\/records repeat themselves for each corresponding column value (if needed). <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: large\">This is not so in the case when we transpose a table using a Rotate option in the Transformation Wizard.<\/span><\/span><\/p>\n<p align=\"justify\">So, this was all about QlikView Interview Questions and Answers. Hope you like our explanation.<\/p>\n<h2 align=\"justify\">Conclusion<\/h2>\n<p>Hence, we cover our 2nd step for success, there are few more to cover. Furthermore, if you have any regarding\u00a0QlikView Interview Questions and Answers, approach us through comment box.<\/p>\n<p>QlikView Interview Questions\u00a0 <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-developer-interview-questions\/\">Part &#8211; 5<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have learned all QlikView Basic Interview Questions in part-1. In this part, we will cover all basic concepts with all these QlikView Interview Questions and Answers. This article helps you to crack QlikView&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":39039,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17405,17402,17399,17403,17447,17406],"class_list":["post-39020","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-advanced-qlikview-interview-questions","tag-qlikview-developer-interview-questions","tag-qlikview-interview-questions","tag-qlikview-interview-questions-and-answers","tag-qlikview-interview-questions-and-answers-for-experienced","tag-qlikview-interview-questions-for-freshers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Interview Questions and Answers - Clear Basic Concept - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Interview Questions and Answers- To crack QlikView Developer Interview, Advance Interview Questions for QlikView, QlikView easy questions\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Interview Questions and Answers - Clear Basic Concept - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Interview Questions and Answers- To crack QlikView Developer Interview, Advance Interview Questions for QlikView, QlikView easy questions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-23T07:30:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:49:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Interview-questions4.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Interview Questions and Answers - Clear Basic Concept - DataFlair","description":"QlikView Interview Questions and Answers- To crack QlikView Developer Interview, Advance Interview Questions for QlikView, QlikView easy questions","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Interview Questions and Answers - Clear Basic Concept - DataFlair","og_description":"QlikView Interview Questions and Answers- To crack QlikView Developer Interview, Advance Interview Questions for QlikView, QlikView easy questions","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-23T07:30:26+00:00","article_modified_time":"2021-12-07T05:49:47+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Interview-questions4.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Interview Questions and Answers &#8211; Clear Basic Concept","datePublished":"2018-11-23T07:30:26+00:00","dateModified":"2021-12-07T05:49:47+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/"},"wordCount":1918,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Interview-questions4.jpg","keywords":["advanced qlikview interview questions","qlikview developer interview questions","qlikview interview questions","qlikview interview questions and answers","qlikview interview questions and answers for experienced","qlikview interview questions for freshers"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/","name":"QlikView Interview Questions and Answers - Clear Basic Concept - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Interview-questions4.jpg","datePublished":"2018-11-23T07:30:26+00:00","dateModified":"2021-12-07T05:49:47+00:00","description":"QlikView Interview Questions and Answers- To crack QlikView Developer Interview, Advance Interview Questions for QlikView, QlikView easy questions","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Interview-questions4.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Interview-questions4.jpg","width":1200,"height":628,"caption":"QlikView Interview Questions and Answers - Clear Basic Concept"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-interview-questions-and-answers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"QlikView Interview Questions and Answers &#8211; Clear Basic Concept"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=39020"}],"version-history":[{"count":10,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39020\/revisions"}],"predecessor-version":[{"id":97649,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39020\/revisions\/97649"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/39039"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=39020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=39020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=39020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}