Data format

[#1]

Hi,

I have some data in the excel as

911040000000000

But in the qlikview its Showing as 9.11e+014

How do i correct this?

Regards,

Keerthi KS

[arulsettu]

what is your expecting output?

[petter]

You can format the number in an expression when you use the field like this:

Num( BigNumber , '000000000000000' )

Anyhow what you see in QlikView is just another way of displaying large numbers using scientific notation. This is the way Excel displays big numbers like this by default. So your Excel sheet has been set up to format them with the maximum number of digits instead of using scientific notation. You can do exactly this also with QlikView - just as I illustrated above - in many places. Either in the Load Script or in the user interface or the expressions being used.

[mohammadkhatimi]

In which format u want in qlikview???

[#5]

same format as in excel

[arulsettu · Accepted solution]

try like this

=num(911040000000000,'#,##0')

[krishna20]

Hi,

If you are showing these values in any chart .Play with Number tab options in chart properties.You will get desired result. After applying the properties in chart if you still get the same output drag the column to right.

Hope this helps.