Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
hugojesus
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
eduardo_dimperio
Specialist II
Specialist II

Maybe this

crosstable (Nationality, Department) LOAD * from Table1