Discussion board where members can get started with Qlik Sense.
Hi I Have table like below...
I want to format as below.How can I do that in qlik sense ?
Use the CROSSTABLE function before your load script.
Crosstable ‒ Qlik Sense
In this case, your script should look something like this:
CROSSTABLE(Season, Performance, 3)
RENAME Field perfomence to Result;
Load * Resident temp1;
Why would you do it in two loads instead of just one?
I thought you wanted to rename the fields thats why