Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
));
Thank you! That is what i'm looking for!
use number fixed to zero dacimal in number tab in properties.