Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Table Organization

Hello,

I have a DataBase like the Table 1 loaded, and I want to create the table 2 in Qlik Sense Cloud, and I don´t know to do?

The most important in the table 2 is the columns name, the values is not important, I only want to transform the rows (DB) into columns.

I try to do this in the column´s

=FirstSortedValue(Nationality,- count(Nationality),1)

But doesn´t work...

NationalityDepartment
Germanyfood
Germanyrestaurant
Germanyroom service
Francefood
Francerestaurant

Table 1 - DataBase

NationalityGermanyFrance
food11
restaurant11
room service10

Table 2 - Transformation

1 Reply
Highlighted
Specialist II
Specialist II

Re: Table Organization

Maybe this

crosstable (Nationality, Department) LOAD * from Table1