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.

[Anonymous]

services:

LOAD id as service_id,

Text([name]) as service_name;

SQL SELECT *

FROM "myhealth_production"."public".services;

No it is coming from database.

[vishsaggi]

So, it still doesn't work ?

[Anonymous]

No.it is still showing  those odd bits

[vishsaggi]

Can you scramble your data and share your actual app ?

[Anonymous]

I have left the office earlier.I shall share it across tomorrow.