Cross Table Issue

[aveeeeeee7en]

Hi All

I am facing issue in Cross Table Result.

Actual Table:

After using Cross Table, I am getting wrong Result:

CrossTable(WeekDays, Data, 3)

LOAD PARENTCUSTOMERNUMBER,

     CustomerName,

     [Serial No],

     Mon,

     Tue,

     Wed,

     Thu,

     Fri,

     Sat,

     Sun

FROM

(ooxml, embedded labels, table is Sheet1);

See the Attachments.

Regards

Av7eN

[aveeeeeee7en]

Any Suggestions????

[jonathandienst]

Hi

Qlikview is converting the numeric values in [Serial No] to some sort of time value, possibly triggered by the time values in the subsequent fields. This fixes the problem:

Table1:

CrossTable(WeekDays, Data, 3)

LOAD PARENTCUSTOMERNUMBER,

     CustomerName,

     Text([Serial No]) As [Serial No],

     Mon,

     Tue,

     Wed,

     Thu,

     Fri,

     Sat,

     Sun

FROM [SampleTest.xlsx]

(ooxml, embedded labels, table is Sheet1);

HTH

Jonathan

[mdmukramali · Accepted solution]

Dear,

Either you can format the cell in the excel to number.

else in qlikview script level

Table:

CrossTable(WeekDays, Data, 3)

LOAD PARENTCUSTOMERNUMBER,

     CustomerName,

     Num#([Serial No]) as [Serial No],

     Mon,

     Tue,

     Wed,

     Thu,

     Fri,

     Sat,

     Sun

FROM

(ooxml, embedded labels, table is Sheet1);

Thanks,
Mukram