Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-10-17 01:00 PM

Transpose on Load

Could anyone show me an example of transposing a file on load in QlikSense please ?

Many Thanks

Chris

4,359 Views
4 Replies
sunny_talwar
MVP
MVP
‎2016-10-17 01:08 PM

AFAIK there is not wizard to do that in Qlik Sense, so I usually create the script for transposing in QlikView and copy paste it into Qlik Sense.

2,731 Views
udit_kumar_sana
Creator II
Creator II
‎2016-10-18 03:05 AM

Hi,

In qliksense, there is no  wizard to transpose as it's in qlikview.

But we can directly use crosstable function in load script in qliksense.

Regards,

Udit

2,731 Views
marcohadiyanto
Partner - Specialist
Partner - Specialist
‎2016-10-18 04:17 AM

Hi Chris,

Please check this link

https://www.youtube.com/watch?v=D_03gU8GvK8

Qlik Sense 3.1 can unpivot data, it looks like transpose your data.

Regards

2,731 Views
lakshmikandh
Specialist II
Specialist II
‎2016-10-18 06:30 AM

Power of Qlik Script - Reshaping Data with Crosstable (video)

Check this one

2,731 Views