I have data as below
but when I add this column in qlikview report it converts to floating values
Thanks in Advance!
it must be CHAR format instead BIGINT, but you all know how does this change impacts on Production database. So, time being, I did this below
SQL SELECT CAST(SerialNumber AS CHAR) from table;
Convert to CHAR before loading into Qlikview that solves my problem ....
Great, Please close this thread by flag "correct answer" of your own response..
Thats a nice solution!