Table Organization

hugojesus — Wed, 25 Nov 2020 16:16:04 GMT

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...

Table 1 - DataBase

Table 2 - Transformation

Re: Table Organization

eduardo_dimperio — Tue, 29 May 2018 17:14:06 GMT

Maybe this

crosstable (Nationality, Department) LOAD * from Table1