Generic Keys

Anonymous — Thu, 29 Oct 2015 04:50:01 GMT

Hi Experts,

Can someone explain me Generic keys with example.

Thanks in advance.

Re: Generic Keys

SreeniJD — Thu, 29 Oct 2015 04:52:52 GMT

Hi Manoj,

Refer this great article by HIC with example on Mixed Granularity

Generic keys

Sreeni

Re: Generic Keys

amit_saini — Thu, 29 Oct 2015 05:02:32 GMT

Hi,

Check:

The Generic Load

Generic keys

Thanks,
AS

Re: Generic Keys

sujeetsingh — Thu, 29 Oct 2015 05:05:08 GMT

@amit has provided you all well Just understand that Generix load is an implementation of left join with loop.

Re: Generic Keys

avinashelite — Thu, 29 Oct 2015 07:09:44 GMT

Check the attachment :

Generic Databases

A generic database is a table in which the field names are stored as field values in one column, while the field values are stored in a second. Generic databases are usually used for attributes of different objects. Consider the example to the right. It is a generic database containing two objects, a ball and a box. Obviously some of the attributes, like color and weight, are common to both the objects, while others, like diameter, height length and width are not.

This is a typical generic database. On one hand it would be awkward to store the data in a way giving each attribute a column of its own, since many of the attributes are not relevant for a specific object. On the other hand, it would look messy displaying it in a way that mixed lengths, colors and weights.

QlikView solves this problem in an elegant way. If data is stored in the compact way shown above, you can choose between the two different ways of displaying the data. QlikView automatically creates several logical tables from the generic database.

If this table is loaded the standard way, we can get three different list boxes on the screen. However, if the table is loaded as a generic database, QlikView will split up column two and three into different list boxes.

QlikView will then generate one field for each unique value of the second column.

topic Re: Generic Keys in QlikView

Generic Keys

Re: Generic Keys

Re: Generic Keys

Re: Generic Keys

Re: Generic Keys