Creating a cross table in qlik sense

[vinay3190]

Hi,

I am pretty new to Qlik Sense and trying to explore its functionalities. I have a cross table in excel which has sales data for each sales rep spread across more than 200 weeks (200 distinct coumns). I want to show this table as is in Qlik Sense. When I try importing this table, I am forced to drag and drop each column in the table object manually. Is there a better way to create a table object which has all the 200 weeks in distinct columns?

I tried unpivoting the data in Qliksense to get all the weeks in a single column. But this doesn't help me recreate the original table. 

Any help would be highly appreciated.

[Somasundaram]

hi,

Try to load with data load editor,

Tablename:

Crosstable(attribute filed name, data fieldname, Numer of columns )

Load 

*

From datasource;

[valnod_90]

Hi! This is a very very easy and useful tutorial to use crosstable function

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