Help in Cross Table to Straight Table script?

dmohanty — Mon, 15 Sep 2014 13:29:57 GMT

Hi All,

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

	Q1'15	Q2'15	Q3'15	Q4'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?

Regards!

Re: Help in Cross Table to Straight Table script?

Mon, 15 Sep 2014 14:08:27 GMT

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

Give it a try

Re: Help in Cross Table to Straight Table script?

JonnyPoole — Mon, 15 Sep 2014 14:09:06 GMT

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

topic Re: Help in Cross Table to Straight Table script? in QlikView

Help in Cross Table to Straight Table script?

Re: Help in Cross Table to Straight Table script?

Re: Help in Cross Table to Straight Table script?