Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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