topic Re: Data format in QlikView

Data format

Tue, 25 Aug 2015 04:26:01 GMT

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

Re: Data format

arulsettu — Tue, 25 Aug 2015 04:30:29 GMT

what is your expecting output?

Re: Data format

petter — Tue, 25 Aug 2015 04:43:33 GMT

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.

Re: Data format

mohammadkhatimi — Tue, 25 Aug 2015 04:44:10 GMT

In which format u want in qlikview???

Re: Data format

Tue, 25 Aug 2015 05:06:48 GMT

same format as in excel

Re: Data format

arulsettu — Tue, 25 Aug 2015 05:14:12 GMT

try like this

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

Re: Data format

krishna20 — Tue, 25 Aug 2015 05:19:49 GMT

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.