Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi,
Try to load with data load editor,
Tablename:
Crosstable(attribute filed name, data fieldname, Numer of columns )
Load
*
From datasource;
Hi! This is a very very easy and useful tutorial to use crosstable function
https://www.youtube.com/watch?v=xkBFyNys1LI