# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for
Did you mean:
Contributor III

## Convert table with diagonal values to vertical table

I currently have the following table in my QlikView application :

 CumRijNummer 29700 -108146 -259585 -443525 -460585 -501017 -382687 -400837 -346605 -281085 719451 529451 1 29700 - - - - - - - - - - - 2 - -108146 - - - - - - - - - - 3 - - -259585 - - - - - - - - - 4 - - - -443525 - - - - - - - - 5 - - - - -460585 - - - - - - - 6 - - - - - -501017 - - - - - - 7 - - - - - - -382687 - - - - - 8 - - - - - - - -400837 - - - - 9 - - - - - - - - -346605 - - - 10 - - - - - - - - - -281085 - - 11 - - - - - - - - - - 719451 - 12 - - - - - - - - - - - 529451 13 - - - - - - - - - - - 529451 14 - - - - - - - - - - - 529451 15 - - - - - - - - - - - 529451 16 - - - - - - - - - - - 529451

I need to convert the table to the following :

 CumRijNummer SaldoLiquideMiddelen 1 29700 2 -108146 3 -259585 4 -443525 5 -460585 6 -501017 7 -382687 8 -400837 9 -346605 10 -281085 11 719451 12 529451 13 529451 14 529451 15 529451 16 529451

What is an easy way to convert this table? I only could find information about convert a table from horizontal to vertical and visa versa.

1 Solution

Accepted Solutions
Partner - Specialist III
```tmp:
Directory;
CrossTable(SaldoLiquideMiddelen, Data)
[29700],
[-108146],
[-259585],
[-443525],
[-460585],
[-501017],
[-382687],
[-400837],
[-346605],
[-281085],
[719451],
[529451]
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
tmp2:
,SaldoLiquideMiddelen
Resident tmp
Where Data = SaldoLiquideMiddelen
;

DROP Table tmp;```

Try the code above.

The results:

2 Replies
Partner - Specialist III
```tmp:
Directory;
CrossTable(SaldoLiquideMiddelen, Data)
[29700],
[-108146],
[-259585],
[-443525],
[-460585],
[-501017],
[-382687],
[-400837],
[-346605],
[-281085],
[719451],
[529451]
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
tmp2:
,SaldoLiquideMiddelen
Resident tmp
Where Data = SaldoLiquideMiddelen
;

DROP Table tmp;```

Try the code above.