Number Format and Cross Table

[#1]

Hello All,

I'm having trouble regarding my data.

Since I have used a cross table for my data, for some reasons it won't look up at my other tables.

My field No. contains the ff:

1.000000

2.000000

etc...

My other table containts the ff:

1.000000

2.000000

etc...

basically the same fields (the primary key)

but they don't meet! How come?

Now I want to format this numbers if it will have an effect. I tried left join, still they won't meet. Any idea?

The format that I want:

1.000000 = 1

2.000000 = 2

and so on..

Thanks.

UPDATE!

It looks like that when I did the cross table, the Numbers are not numbers anymore. If I use the format num() to my field,

it returns empty!

P.S This is my cross table result:

"January":

CrossTable(No, Data, 4)

LOAD No. as Month,

     F2 as Type,

     F3 as Patient_Type,

     F4 as H_P,

     [1.000000],

     [2.000000],

     [3.000000],

     [4.000000],

     [5.000000],

     [6.000000],

     [7.000000],

     [8.000000],

     [9.000000],

     [10.000000],

     [11.000000],

     [12.000000],

     [13.000000],

     [14.000000],

     [15.000000],

     [16.000000],

     [17.000000],

     [18.000000],

     [19.000000],

     [20.000000],

     [21.000000],

     [22.000000],

     [23.000000],

     [24.000000],

     [25.000000],

     [26.000000],

     [27.000000],

     [28.000000],

     [29.000000]

FROM

C:\QlikViewData\QVD\MD\January.xlsx

(ooxml, embedded labels, table is [Regular ], filters(

Transpose(),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null)),

Replace(3, top, StrCnd(null))

));

[#2]

Thank you! That is what i'm looking for!

[#3]

use number fixed to zero dacimal in number tab in properties.