Qlikview imports only the first line of a pivot table!

[#1]

Hello ! I am new to Qlikview and I have the following problem.

I am trying to import a pivot table using the fill option into qlikview and no matter what I have tried qlikveiw loads only the first line of the pivot.

below is my load script

SET

ThousandSep=

"'";

SET

DecimalSep='.'

;

SET

MoneyThousandSep=

"'";

SET

MoneyDecimalSep='.'

;

SET

MoneyFormat='SFr. #''##0.00;SFr.-#''##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;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez'

;

SET

DayNames='Mo;Di;Mi;Do;Fr;Sa;So'

;

Directory;

LOAD

* FROM ytd.xls (biff, header is 5 lines, embedded labels, table is Pivot$, filters

(

Replace

(1, top, StrCnd(null

)),

Replace

(2, top, StrCnd(null

))

))

;

any help would be very appreciated.

thanks

[#2]

Hi,

can you please post the loaded xls file ?

Best regards

[#3]

Here it is ( and since I changed the excel file I attach the new script)

Directory;
LOAD Account,
Brand,
Total
FROM test.xls (biff, header is line, embedded labels, table is Sheet4$, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));

thanks a lot in advance!

[prieper]

Script should be something like

Data:
 LOAD Account,
 Brand,
 Total
 FROM
 [.\test.xls]
 (biff, embedded labels, header is 1 lines, table is Sheet4$, filters(
 Replace(1, top, StrCnd(null))
 ))
 WHERE
 NOT WILDMATCH(Account, '*Total');

HTH
Peter

[#5]

I did it but still the same result.

do you want me to post my qlikview file ?

Savvas

[#6]

The script added by Peter should works,

- In your script, do not forget to erase the header line (the line with the label "Sum of Sales" in your excel).
- I advise you to calculate the partial sums in QlikView directly (that the meaning of the "NOT WILDMATCH(Account, '*Total')" instruction in Peter' script which delete all "total" lines).

Regards

[#7]

I'm surprised that your problem isn't solved ?

Can you please upload the qvw ?

[#8]

Here it is.

My problem is that even with a singe multibox I only get the option to select the items from the 1st line!

[#9]

which QlikView version are you using ?

your qvw works on my computer (after a reload) ??

Regards

[#10]

I am using version 8.5.

could be this the problem?