How to stop this odd behaviour on pivot table

[Anonymous]

Hi,

I am pulling a pivot table into the excel sheet.

Strangely it is showing these figures in excel sheet but not in Qlikview pivot table.How to stop these.Figure 1 is in qlikview.

Fiigure 2 is in Excel sheet.

[vinieme12]

I think the cells are merged, wrap text to 3 or 4 lines to see if they are showing up in Service type column

[Anonymous]

Yes i tried but it is doing nothing.

[Anil_Babu_Samineni]

Can you share that Excel file and meantime Qlikview File if possible

[Anonymous]

why i am unable to attach any qlikivew or excel file?

[Anonymous]

This is the sample file and you can see top column near month/year  that is displaying jan/1900

[Anonymous]

Hi ,

This is the sample file i have uploaded . where ever there is integer data type .

In this example service type has got 4 and next to that DATE column which is pivoted is giving the odd behaviour when i am sending this pivot to excel sheet.

You can notice that in this qvw.

[vishsaggi · Accepted solution]

May be try this ?

LOAD date, [Group name],  TEXT([Service Type]) AS ServiceType;

LOAD date,

     [Group name],

     [Service Type]

FROM

<Youraexcelpath>

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

[Anonymous]

Yes that load script has done the trick when i was using my sample file.

But the same code is not working for QVW.

[vishsaggi]

Use same for your actual load script where you pulling your Service Type from. Is your service type a calculated field or is that coming from an excel source or any other source? Can you share your actual script by scrambling?