How to convert Cross Table into Straight Table in Qlikview?

qlikview
straighttable
crosstable

#1

Hi,

I have raw data available in a cross table format, now I want to load this cross table as straight table in Qlikview.

Cross Table

Output Table

Please guide me to perform this.

Thx,
Mukesh


#2

@Mukesh

In Qlikview, there is option to load data from cross table. Follow below steps to perform this:

**Step-1:**Go to Edit Script and select the data source (Excel, CSV …)

Step-2: Click on next button twice and after that click on CrossTable.

Above, you can select Qualifier fields, Name for Attribute Filed and Data Values. You can see the color combination with these related filed also. Press OK. Now Data is converted to Straight Table.

Now, Click on Finish.

Here you can see the code for loading cross table also.

Directory;
CrossTable(Year, Data)
LOAD Region, 
     [2009], 
     [2010], 
     [2011], 
     [2012], 
     [2013], 
     [2014]
FROM
Data.xlsx
(ooxml, embedded labels, table is Data);

Hope this helps!

Regards,
Sunil