Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

Help in Cross Table to Straight Table script?

Hi All,

Initally I was having a Cross Table data in excel like this below format and the QV script below,

Q1'15Q2'15Q3'15Q4'15
IND        68.2        72.3        77.3        82.2
USA        40.5        42.9        45.9        48.8
JPN        43.2        45.8        49.0        52.1
CAN        25.5        27.0        28.9        30.7
AUS        11.4        12.1        12.9        13.7
UK          9.1          9.6        10.3        11.0
NZ          2.3          2.4          2.6          2.7

The sript was like this below:

CrossTable(Quarter,Sales,1)

LOAD

    

     Country,

     [Q1'15],

     [Q2'15],

     [Q3'15],

     [Q4'15]

From .........

Now the revised Cross Table format is like below, now we have Month field also below Quarter(Ignore the data please). How wil be the script for this to convert into a Straight table and load in QVD?

CrossTable.jpg

Regards!

2 Replies
Not applicable

You can use the Table Wizzard and set "Embedded Labels" and Header = 1 Line.

Give it a try

JonnyPoole
Employee
Employee

The data load wizard + crosstable wizard is probably best to help you. Here are some screenshots to help you:

Capture1.PNG.png

Capture2.PNG.png

Capture3.PNG.png

Capture4.PNG.png