11 Replies Latest reply: Feb 7, 2013 3:37 AM by Muhammad Asim RSS

    Number Format and Cross Table

      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))

      ));