Information Density represents percentage of records that have not NULL values for a field.

Example:

After loading the above records, go to the table viewer section (CTRL+T)

mouse hover on “country” field, you will see Information density is 100%

Now mouse hover on “code” field, you will see Information density is less than 100% i.e 67%

It means that, code field contains a null value in 2nd row that’s why it is showing Information density is 67%

Perfect Key:

It indicates that every row contains a key value, and that all of these key values are unique. At the same time, the field’s subset ratio is 100 percent. This qualifier should be seen in dimension tables, where every key should uniquely identify a single record.

Primary Key:

It indicates that all key values are unique, but not every row contains a key value or the field’s subset ratio is less than 100 percent.

Key:

It indicates that the key is not unique. This qualifier is usually seen in fact tables, where the same dimension value may be associated with many different facts.

The basic need of the bundle is when we need to move the application from one machine to other and we dont want to transfer the files associated with it. so the bundle store the info inside the Qlik View Document itself and do not need to be moved with the application.

qlikview-technical-brief-loading-images-into-qlikview

How to fetch first N number of records from database in the script editor?

There is a keyword called ‘FIRST’, which comes handy while you want to avoid Qlikview application hang or to avoid long time load.

Pick and Match combination will come in use when to view field value ‘x’ when field value is ‘y’.

Example:

Display Quarter value as Q1, Q2, Q3 and Q4. Instead of showing database values.

Pick(MATCH (-1,TIME_CALENDAR_QUARTER = 1, TIME_CALENDAR_QUARTER = 2, TIME_CALENDAR_QUARTER = 3,-1), ‘Q1’, ‘Q2’, ‘Q3′,’Q4’) as TIME_CALENDAR_QUARTER