Cross Tables

[marco_puccetti]

Hello i need to create a Table structured like this:

Year	Metal	Kg
2000	Copper	17
2000	Silver	14
2000	Gold	25
2001	Copper	20
2001	Silver	21
2001	Gold	22

From a csv with this data inside:

Year	Copper	Silver	Gold
2000	17	14	25
2001	20	21	22

Anybody Knows how it can be made using cross tables?

Thank you

Marco

[orital81]

Hi Marco

The result of crosstable is that the column headers (Copper,Silver,Gold) will be stored in one field (Metal) the attribute field, the column data will be stored in a second field (KG).

For more info go to Qlikview Help index.

Hope this was useful for you.

Ori