topic Re: Cross Table Issue in QlikView

Cross Table Issue

aveeeeeee7en — Tue, 14 Oct 2014 04:59:09 GMT

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

Re: Cross Table Issue

aveeeeeee7en — Tue, 14 Oct 2014 05:29:44 GMT

Any Suggestions????

Re: Cross Table Issue

jonathandienst — Tue, 14 Oct 2014 05:44:08 GMT

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

Re: Cross Table Issue

mdmukramali — Tue, 14 Oct 2014 05:45:27 GMT

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