Home  >  Blog  >   QlikView

QlikView Table Viewer - Previews Records

Rating: 5
  
 
3617

The QlikView table viewer is a graphical tool that QlikView developers use to visualize the QlikView data model.

The Qlikview Table Viewer is the ability to view the data inside QlikView tables in the data model. To view data (limited to the first 1000 rows in the table), left-click on the table title bar, and click on Preview. A dialog box displays the data fields in the selected table. This is useful when you are building a script, so you can check the outcomes for a particular change.

Qlikview table viewer – Previews Records in Tables:

Learn how to use QlikView, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll in Free QlikView Training Demo!

In the following example, we are previewing the data fields in the Physician Order Facts table. This table has 17 rows, all of which are displayed in the dialog box.

 Order Facts table

If you want to go beyond previewing data in tables using Table Viewer, you can also view data in individual QVD files. There is a great third-party tool for doing just that: QViewer, or EasyQlik is a very fast and small footprint standalone file viewer for analyzing the QVD files.

MindMajix YouTube Channel

 

Related Article: Qlikview Interview Questions and Answers for Experienced

QlikView can view all data inside a QVD file (or partial data for large files), create date stamps, field duplicates, null values, and count basic aggregations. QViewer/ EasyQlik can also help you view data in a resident table, with an addition of a small code block inside the script. The free version is limited to previewing 50,000 rows per table, and the full-price version is unlimited. QViewer/ EasyQlik is available for download at https:// www.easyqlik.com/

Information density and subset ratios:

You can view information about each data field in a table in Table Viewer by placing your cursor on any data field in any table. A tooltip displays (as shown in the following screenshot) the information about the data field, consisting:

Related Article: QVD in QlikView
  • Information density: This displays the percentage of rows in the table with values (none is null).

  • Subset ratio: This displays the percentage of distinct values in this table for the data field (out of all possible distinct values for the data field having in all tables).

  • Field comments (if any): These are added with the help of the Comment Field statement, as follows:

          Comment fieldname with ‘any comment’;

  • Field tags: These may be auto-populated from the system (denoted by a preceding dollar sign $). Custom field tags may also be added and edited by navigating to Settings | Document .. | Tables | Fields | Edit Tags | Add. An example of the use of field tags is to mark fields as dimensions or measures.

Explore QlikView Sample Resumes! Download & Edit, Get Noticed by Top Employers!

 

Field tags

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
QlikView TrainingFeb 27 to Mar 13View Details
QlikView TrainingMar 02 to Mar 17View Details
QlikView TrainingMar 05 to Mar 20View Details
QlikView TrainingMar 09 to Mar 24View Details
Last updated: 03 Apr 2023
About Author

Vinod Kasipuri is a seasoned expert in data analytics, holding a master's degree in the field. With a passion for sharing knowledge, he leverages his extensive expertise to craft enlightening articles. Vinod's insightful writings empower readers to delve into the world of data analytics, demystifying complex concepts and offering valuable insights. Through his articles, he invites users to embark on a journey of discovery, equipping them with the skills and knowledge to excel in the realm of data analysis. Reach Vinod at LinkedIn.

read more
Recommended Courses

1 / 15