Cross Table Load in Differences between Wizard Result and Actual

Thu, 03 May 2012 09:50:18 GMT

Hi,

I'm having an issue where when loading in a set of data via Cross Table, the Wizard Result is showing correctly but when i load the data it comes out differently.

For Example; the Wizard shows

and displays the values correctly as per below in the Results

However, when i load the report, it displays the below instead

Here's the load in script it creates;

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

CrossTable([Financial Week #], Data, 2)
LOAD Porfolio,
     [Actual / Forecast],
     1,
     2,
     3,
     4,
     5,
     6,
     7,
     8,
     9,
     10,
     11,
     12,
     13,
     14,
     15,
     16,
     17,
     18,
     19,
     20,
     21,
     22,
     23,
     24,
     25,
     26,
     27,
     28,
     29,
     30,
     31,
     32,
     33,
     34,
     35,
     36,
     37,
     38,
     39,
     40,
     41,
     42,
     43,
     44,
     45,
     46,
     47,
     48,
     49,
     50,
     51,
     52
FROM

(biff, embedded labels, table is Margin$);

I'm not changing anything between clicking 'Finish' in the Wizard and clicking 'Reload' but the data just wont load how i'm expecting it to.

Is this a Bug or am i doing something wrong?

Thanks in advance.

Cross Table Load in Differences between Wizard Result and Actual

martinpohl — Thu, 03 May 2012 10:01:06 GMT

I think it's a bug,

it happens to me too.

I think it is because of the numbers in your caption.

Set the number in brackets

[1],

[2],

and you will get the right result.

Regards

Cross Table Load in Differences between Wizard Result and Actual

Thu, 03 May 2012 10:28:20 GMT

Excellent.

Thanks very much!

Regards,

Nick

topic Cross Table Load in Differences between Wizard Result and Actual in QlikView

Cross Table Load in Differences between Wizard Result and Actual

Cross Table Load in Differences between Wizard Result and Actual

Cross Table Load in Differences between Wizard Result and Actual